Re: Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace] - Mailing list pgsql-performance

From Greg Smith
Subject Re: Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace]
Date
Msg-id 4E7A0D02.6050808@2ndQuadrant.com
Whole thread Raw
In response to Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace]  (Guillaume Cottenceau <gc@mnc.ch>)
List pgsql-performance
On 09/21/2011 08:43 AM, Guillaume Cottenceau wrote:
> AI Rumman<rummandba 'at' gmail.com>  writes:
>
>
>> Using the query http://wiki.postgresql.org/wiki/Show_database_bloat, I got the
>>
> Is this stuff to show database bloat reliable?

Only in that increase and decreases of the number reported can be useful
for determining if bloat is likely increasing or decreasing--which is
the purpose of that query.  The value returned is a rough estimate, and
should not be considered useful as any sort of absolute measurement.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow query with self-join, group by, 100m rows
Next
From: Venkat Balaji
Date:
Subject: Re: : Performance Improvement Strategy