Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BD9739FB774 for ; Tue, 19 Jun 2007 13:04:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 96005-03 for ; Tue, 19 Jun 2007 13:04:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 529669FB703 for ; Tue, 19 Jun 2007 13:04:22 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l5JG4Jta000161; Tue, 19 Jun 2007 12:04:19 -0400 (EDT) To: Chris Browne cc: pgsql-performance@postgresql.org Subject: Re: Maintenance question / DB size anomaly... In-reply-to: <607iq0dlns.fsf@dba2.int.libertyrms.com> References: <607iq0dlns.fsf@dba2.int.libertyrms.com> Comments: In-reply-to Chris Browne message dated "Tue, 19 Jun 2007 11:11:19 -0400" Date: Tue, 19 Jun 2007 12:04:19 -0400 Message-ID: <160.1182269059@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/360 X-Sequence-Number: 25393 Chris Browne writes: > kurt@hotdogrecords.com (Kurt Overberg) writes: >> In my investigation of this anomaly, I noticed that the data/ dir on >> db1 (the master) is around 60 Gigs. The data directory on the slaves >> is around 25Gb. After about 3 months of head scratching, someone on >> the irc channel suggested that it may be due to index bloat. > I'd be inclined to head to the filesystem level, and try to see what > tables are bloated *there*. At least as a first cut, it should be sufficient to look at pg_class.relpages, which'd be far easier to correlate with table names ;-). The relpages entry should be accurate as of the most recent VACUUM on each table, which ought to be close enough unless I missed something about the problem situation. regards, tom lane