> 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