Improve COPY performance into table with indexes.

I am using the COPY command to insert 10 million rows from a CSV file into a database table and I am finding the performance is unacceptable. When the COPY command is executed the disk I/O is extremely high which leads to degraded query performance for other queries being executed on the database.

SELECT query results are different depending on whether table statistics are available.

has been ANALYZED yet. Could anyone share knowledge about why this is happening? Thanks, James Brauman

Re: SELECT query results are different depending on whether table statistics are available.

Thanks for the help David, the query was missing a column in a PARTITION BY expression. On Thu, May 28, 2020 at 1:14 PM David G. Johnston wrote: > > On Wed, May 27, 2020 at 8:09 PM James Brauman > wrote: >> >> -- Run select query (involving several CTEs). >>