pg_dump slow

From: "Franklin Haut" <franklin(dot)haut(at)gmail(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: pg_dump slow
Date: 2005-11-30 13:35:05
Message-ID: 000201c5f5b2$e0dc87a0$8500a8c0@FRANKLIN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 be that a configuration in the priorities of the exists
processes ? in Windows XP the processing of schemes goes 70% and
constant accesses to the HardDisk, while that in windows 2000 it does
not pass of 3%.

thanks

Franklin

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2005-11-30 13:56:41 Re: pg_dump slow
Previous Message Chris Browne 2005-11-29 18:48:49 Re: index auto changes after copying data ?