: '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
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
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
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
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
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
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
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
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
, 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
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
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
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.
13 matches
Mail list logo