From: Evgeny Gridasov <eugene@i-free.ru>
To: pgsql-performance@postgresql.org
Subject: Re: pg_dump issue
Date: Fri, 2 Jun 2006 16:17:35 +0400
Message-ID: <20060602161735.2a24bc5a.eugene@i-free.ru> (raw)
In-Reply-To: <9765373733A7DF4681B12225D2FC44050D6D0C@bosexprod001.bostonstock.local>
References: <9765373733A7DF4681B12225D2FC44050D6D0C@bosexprod001.bostonstock.local>
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
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: eugene@i-free.ru
Subject: Re: pg_dump issue
In-Reply-To: <20060602161735.2a24bc5a.eugene@i-free.ru>
* 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