ENC: RES: [PERFORM] pg_dump slow - Solution

2006-01-23 Thread Franklin Haut
: 'Ron'; pgsql-performance@postgresql.org Assunto: Re: RES: [PERFORM] pg_dump slow Franklin Haut wrote: Hi, Yes, my problem is that the pg_dump takes 40 secs to complete under WinXP and 50 minutes under W2K! The same database, the same hardware!, only diferrent Operational Systems

Re: [PERFORM] pg_dump slow

2005-12-02 Thread Merlin Moncure
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

Re: [PERFORM] pg_dump slow

2005-12-02 Thread Merlin Moncure
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

[PERFORM] pg_dump slow

2005-12-01 Thread Franklin Haut
I Maked a new install on machine this night, and the same results, on console localhost Windows 2000 Server Version 5.00.2195 PG Version 8.1 Franklin 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

Re: [PERFORM] pg_dump slow

2005-12-01 Thread Merlin Moncure
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

[PERFORM] pg_dump slow

2005-11-30 Thread Franklin Haut
Hi i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes to do backup of 200Mb data ( with no compression, and 15Mb with compression), but in windows XP does not pass of 40 seconds... :( This happens with 8.1 and version 8.0, somebody passed for the same situation? It will

Re: [PERFORM] pg_dump slow

2005-11-30 Thread Ron
At 08:35 AM 11/30/2005, Franklin Haut wrote: Hi i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes to do backup of 200Mb data ( with no compression, and 15Mb with compression), Compression is reducing the data to 15/200= 3/40= 7.5% of original size? but in windows XP

RES: [PERFORM] pg_dump slow

2005-11-30 Thread Franklin Haut
PROTECTED] Enviada em: quarta-feira, 30 de novembro de 2005 10:57 Para: Franklin Haut; pgsql-performance@postgresql.org Assunto: Re: [PERFORM] pg_dump slow At 08:35 AM 11/30/2005, Franklin Haut wrote: Hi i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes to do backup of 200Mb

Re: [PERFORM] pg_dump slow

2005-11-30 Thread Merlin Moncure
At 08:35 AM 11/30/2005, Franklin Haut wrote: Hi i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes to do backup of 200Mb data ( with no compression, and 15Mb with compression), Compression is reducing the data to 15/200= 3/40= 7.5% of original size? but in

RES: [PERFORM] pg_dump slow

2005-11-30 Thread Franklin Haut
, 30 de novembro de 2005 13:57 Para: Ron Cc: pgsql-performance@postgresql.org; Franklin Haut Assunto: RE: [PERFORM] pg_dump slow At 08:35 AM 11/30/2005, Franklin Haut wrote: Hi i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes to do backup of 200Mb data

Re: RES: [PERFORM] pg_dump slow

2005-11-30 Thread Ron
At 12:27 PM 11/30/2005, Richard Huxton wrote: Franklin Haut wrote: Hi, Yes, my problem is that the pg_dump takes 40 secs to complete under WinXP and 50 minutes under W2K! The same database, the same hardware!, only diferrent Operational Systems. The hardware is:Pentium4 HT 3.2 GHz 1024

Re: RES: [PERFORM] pg_dump slow

2005-11-30 Thread Merlin Moncure
By default W2K systems often had a default TCP/IP packet size of 576B and a tiny RWIN. Optimal for analog modems talking over noisy POTS lines, but horrible for everything else wrong. default MTU for windows 2000 server is 1500, as was NT4. http://support.microsoft.com/?id=140375 However

Re: RES: [PERFORM] pg_dump slow

2005-11-30 Thread Ron
At 05:13 PM 11/30/2005, Merlin Moncure wrote: By default W2K systems often had a default TCP/IP packet size of 576B and a tiny RWIN. Optimal for analog modems talking over noisy POTS lines, but horrible for everything else wrong. default MTU for windows 2000 server is 1500, as was NT4.