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). >>

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

anyone share knowledge about why this is happening? Thanks, James Brauman

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.