X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 18B269FA5FB for ; Tue, 30 May 2006 12:16:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 27939-02 for ; Tue, 30 May 2006 12:16:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 6852D9FA5E2 for ; Tue, 30 May 2006 12:16:00 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k4UFFmUH024065; Tue, 30 May 2006 11:15:48 -0400 (EDT) To: "mcelroy, tim" cc: pgsql-performance@postgresql.org Subject: Re: pg_dump issue In-reply-to: <9765373733A7DF4681B12225D2FC44050D6D0C@bosexprod001.bostonstock.local> References: <9765373733A7DF4681B12225D2FC44050D6D0C@bosexprod001.bostonstock.local> Comments: In-reply-to "mcelroy, tim" message dated "Tue, 30 May 2006 10:31:08 -0400" Date: Tue, 30 May 2006 11:15:48 -0400 Message-ID: <24064.1149002148@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/525 X-Sequence-Number: 19312 "mcelroy, tim" writes: > 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. Are the resulting backup files identical? Chasing down the reasons for any diffs might yield some enlightenment. One idea that comes to mind is that Prod002 is having performance problems due to table bloat (maybe a missing vacuum cron job or some such). A quick "du" on the two $PGDATA directories to check for significant size differences would reveal this if so. regards, tom lane