: '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 dife
> 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
>
> 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
>
> >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
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 happen
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.
ht
> 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 t
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 MB
, 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
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 Mb Memory
HD 120Gb SATA
There have been
> 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?
>
>
lto:[EMAIL 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
>m
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 do
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 b
14 matches
Mail list logo