: '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
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
Complementing...
The test was maked at the same machine ( localhost ) at Command-Prompt,
no client´s connected, no concurrent processes only PostgreSQL running.
In windows XP, exists much access to the processor (+- 70%) and HD (I
see HD Led allways on), while in the W2K almost without activity
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
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
Im has make again the test, and then real
