Skip site navigation (1) Skip section navigation (2)

Re: RES: pg_dump slow

From: Richard Huxton <dev(at)archonet(dot)com>
To: Franklin Haut <franklin(dot)haut(at)gmail(dot)com>
Cc: 'Ron' <rjpeace(at)earthlink(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: RES: pg_dump slow
Date: 2005-11-30 17:27:35
Message-ID: 438DE107.9000507@archonet.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Brad MightDate: 2005-11-30 19:21:07
Subject: Select with grouping plan question
Previous:From: Merlin MoncureDate: 2005-11-30 16:56:50
Subject: Re: pg_dump slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group