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

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 (view raw or flat)
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

pgsql-performance by date

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

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