From: Richard Huxton <dev@archonet.com>
To: Franklin Haut <franklin.haut@gmail.com>
Cc: Ron <rjpeace@earthlink.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: RES: pg_dump slow
Date: Wed, 30 Nov 2005 17:27:35 +0000
Message-ID: <438DE107.9000507@archonet.com> (raw)
In-Reply-To: <000401c5f5ca$0aed7420$8500a8c0@FRANKLIN>
References: <000401c5f5ca$0aed7420$8500a8c0@FRANKLIN>
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 reports of very slow network performance on Win2k
systems with the default configuration. You'll have to check the
archives for details I'm afraid. This might apply to you.
If you're happy that doesn't affect you then I'd look at the disk system
- perhaps XP has newer drivers than Win2k.
What do the MS performance-charts show is happening? Specifically, CPU
and disk I/O.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, franklin.haut@gmail.com, rjpeace@earthlink.net
Subject: Re: RES: pg_dump slow
In-Reply-To: <438DE107.9000507@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox