Re: Improve COPY performance into table with indexes.

2020-04-03 Thread Rob Sargent
On 4/3/20 9:52 AM, Adrian Klaver wrote: On 4/2/20 9:42 PM, James Brauman wrote: 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

Re: Improve COPY performance into table with indexes.

2020-04-03 Thread Adrian Klaver
On 4/2/20 9:42 PM, James Brauman wrote: 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 othe

Re: Improve COPY performance into table with indexes.

2020-04-03 Thread Laurenz Albe
On Fri, 2020-04-03 at 18:27 +1100, Tim Cross wrote: > > 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

Re: Improve COPY performance into table with indexes.

2020-04-03 Thread Tim Cross
James Brauman writes: > 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 > quer