Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 40B3AB5DC1B for ; Wed, 21 Sep 2011 11:13:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 33024-01 for ; Wed, 21 Sep 2011 14:12:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 55B04B5DC1A for ; Wed, 21 Sep 2011 11:12:54 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p8LECqmv022060; Wed, 21 Sep 2011 10:12:52 -0400 (EDT) To: sthomas@peak6.com cc: AI Rumman , pgsql-performance@postgresql.org Subject: Re: REINDEX not working for wastedspace In-reply-to: <4E79E702.4090405@peak6.com> References: <4E79E702.4090405@peak6.com> Comments: In-reply-to Shaun Thomas message dated "Wed, 21 Sep 2011 08:30:42 -0500" Date: Wed, 21 Sep 2011 10:12:52 -0400 Message-ID: <22059.1316614372@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201109/319 X-Sequence-Number: 45095 Shaun Thomas writes: > On 09/21/2011 02:01 AM, AI Rumman wrote: >> Using the query http://wiki.postgresql.org/wiki/Show_database_bloat, >> I got the following result for a table: > God. I wish they would erase that Wiki page, or at least add a > disclaimer. That query is no better than a loose estimate. Never, ever, > ever depend on it for critical information about your tables. Ever. The PG wiki is editable by anyone who signs up for an account. Feel free to put in an appropriate disclaimer, or improve the sample query. regards, tom lane