[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: Show_database_bloat reliability? [was: Re: [PERFORM] REINDEX
From:       Greg Smith <greg () 2ndQuadrant ! com>
Date:       2011-09-21 16:12:50
Message-ID: 4E7A0D02.6050808 () 2ndQuadrant ! com
[Download RAW message or body]

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]