Re: [PERFORM] COPY into table too slow with index: now an I/O question

once the table has, say, 50 million rows. > -Original Message- > From: Luke Lonergan [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 01, 2005 9:27 PM > To: Rick Schumeyer; pgsql-performance@postgresql.org > Subject: Re: [PERFORM] COPY into table too slow with index: n

Re: [PERFORM] COPY into table too slow with index: now an I/O question

As a follow up to my own question:   I reran the COPY both ways (with the index and without) while running iostat.  The following values are averages: %user  %nice  %sys  %iowait %idle no index  39  0 2.8    11  47 index 16  1.5   2.1    34