Re: COPY performance

Nigel J. Andrews wrote:
 >
 >
 > I should have mentioned that I'm doing the copy in to the table in a
 > transaction block with all constraints deferred. That should mean
 > it's only at the commit stage that foreign key will be checked
 > right?
 >

I'm not really sure, maybe someone else can chime in.

But I can say that I imported about 38 million rows of similar size
(actually, a bit larger) using COPY in under an hour with 7.2RC3. I had
no indexes or references defined during the COPY. I never saw memory use
grow beyond about 10MB IIRC -- possibly in part because I forgot to
increase shared buffers beyond the default before I started.

FWIW, hardware was dual P3 833 (I think), with 2GB RAM, hardware
mirrored SCSI hard-drives, Red Hat 7.2.

Joe