> How are you dumping out your archive? I confirmed unreasonably slow dump > with pg_dump -Z temp2 > temp2.bkp on windows 2000 server. I normally use > bzip to compress my dumps. > > Can you measure time to dump uncompressed and also with bzip and compare? > > Merlin oops...cancel that. I was dumping the wrong database. Dumping your table from localhost on a dual Opteron win2k server took a few seconds with Z=0 and Z=9. Merlin
