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@xxxxxxxxxxxxxxx> 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
