Re: REINDEX not working for wastedspace - Mailing list pgsql-performance

From Tom Lane
Subject Re: REINDEX not working for wastedspace
Date
Msg-id 22059.1316614372@sss.pgh.pa.us
Whole thread Raw
In response to Re: REINDEX not working for wastedspace  (Shaun Thomas <sthomas@peak6.com>)
Responses Re: REINDEX not working for wastedspace  (Shaun Thomas <sthomas@peak6.com>)
List pgsql-performance
Shaun Thomas <sthomas@peak6.com> 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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: : Performance Improvement Strategy
Next
From: Andy Lester
Date:
Subject: Re: REINDEX not working for wastedspace