From: Franklin Haut <franklin.haut@gmail.com>
To: pgsql-performance@postgresql.org
Subject: ENC: RES: pg_dump slow - Solution
Date: Mon, 23 Jan 2006 07:46:27 -0300
Message-ID: <001701c6200a$44933e20$8500a8c0@FRANKLIN> (raw)
Hi,
Finally i found the problem of slow backup/restore, i´m only instaled de
Windows 2000 Service Pack 4... :)
Thanks to all
Franklin
-----Mensagem original-----
De: Richard Huxton [mailto:dev@archonet.com] Enviada em: quarta-feira, 30 de
novembro de 2005 14:28
Para: Franklin Haut
Cc: '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.
>
> 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: franklin.haut@gmail.com
Subject: Re: ENC: RES: pg_dump slow - Solution
In-Reply-To: <001701c6200a$44933e20$8500a8c0@FRANKLIN>
* 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