Re: Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace]

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace]
Date: 2011-09-21 16:12:50
Message-ID: 4E7A0D02.6050808@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Venkat Balaji 2011-09-21 16:13:45 Re: : Performance Improvement Strategy
Previous Message Tom Lane 2011-09-21 15:02:42 Re: Slow query with self-join, group by, 100m rows