X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ED6909FCF76 for ; Mon, 28 Aug 2006 11:48:30 -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 62425-06 for ; Mon, 28 Aug 2006 11:48:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 3F2CA9FCF87 for ; Mon, 28 Aug 2006 11:48:20 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1GHiPT-0002Z0-Bz; Mon, 28 Aug 2006 10:48:19 -0400 Subject: Re: Identifying bloated tables From: Brad Nicholson To: Michal Taborsky - Internet Mall Cc: pgsql-performance@postgresql.org In-Reply-To: <44F30022.1000009@mall.cz> References: <44F30022.1000009@mall.cz> Content-Type: text/plain Date: Mon, 28 Aug 2006 10:48:18 -0400 Message-Id: <1156776499.10296.5.camel@dba5.int.libertyrms.com> Mime-Version: 1.0 X-Mailer: Evolution 2.6.2 (2.6.2-1.fc5.5) Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.298 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/437 X-Sequence-Number: 20622 On Mon, 2006-08-28 at 16:39 +0200, Michal Taborsky - Internet Mall wrote: > I just put together a view, which helps us in indentifying which > database tables are suffering from space bloat, ie. they take up much > more space than they actually should. I though this might be useful for > some folk here, because the questions about bloat-related performance > degradation are quite common. Are you sure you haven't reinvented the wheel? Have you checked out contrib/pgstattuple ? Brad.