Thread: Re: pg_dump slow

> >Franlin: are you making pg_dump from local or remote box and is this
a
> >clean install?  Try fresh patched win2k install and see what happens.
> He claimed this was local, not network.  It is certainly an
> intriguing possibility that W2K and WinXP handle bytea
> differently.  I'm not competent to comment on that however.

can you make small extraction of this file (~ 100 rows), zip to file and
send to me off list?  I'll test it vs. a 2000 and xp server and try to
reproduce your results.

Merlin

>
> That was the command used to restore a database
>
> pg_restore.exe -i -h localhost -p 5432 -U postgres -d temp2 -v
> "D:\d\temp.bkp"
>
> The database was created before using LATIN1 charset
>
> With 100 rows you can´t feel the test, then I decided send the whole
> table.
>
> Very Thanks
>
> Franklin Haut

How are you dumping out your archive?  I confirmed unreasonably slow dump with pg_dump -Z temp2 > temp2.bkp on windows
2000server.  I normally use bzip to compress my dumps. 

Can you measure time to dump uncompressed and also with bzip and compare?

Merlin

> 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