Date: Fri, 2 Jun 2006 16:17:35 +0400
From: Evgeny Gridasov <eugene@i-free.ru>
To: pgsql-performance@postgresql.org
Subject: Re: pg_dump issue
Message-Id: <20060602161735.2a24bc5a.eugene@i-free.ru>
In-Reply-To: 
 <9765373733A7DF4681B12225D2FC44050D6D0C@bosexprod001.bostonstock.local>
References: 
 <9765373733A7DF4681B12225D2FC44050D6D0C@bosexprod001.bostonstock.local>
Organization: i-free.ru
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit


try to dump-restore your 'slow' database,
this might help if your db or filesystem gets too fragmented.

On Tue, 30 May 2006 10:31:08 -0400
"mcelroy, tim" <tim.mcelroy@bostonstock.com> wrote:

> Good morning,
> 
> I have identical postgres installations running on identical machines.  Dual
> Core AMD Opteron(tm) Processor 870 , 16GB RAM, Red Hat Linux 3.2.3-20 and
> 120GB worth of disk space on two drives.
> 
> Recently, I have noticed that my nightly backups take longer on one machine
> than on the other.  I back up five (5) databases totaling 8.6GB in size.  On
> Prod001 the backups take app. 7 minutes, on Prod002 the backups take app. 26
> minutes!  Quite a discrepancy.  I checked myself than checked with our
> Engineering staff and have been assured that the machines are identical
> hardware wise, CPU, disk, etc.  
> 
> Question; has anyone run into a similar issue?  Here is the command I use
> for the nightly backup on both machines:
> 
> pg_dump -F c -f $DB.backup.$DATE $DB
> 
> Kind of scratching my head on this one....
> 
> Thank you,
> Tim McElroy
> 
> 


-- 
Evgeny Gridasov
Software Engineer 
I-Free, Russia