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

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace]
Дата
Msg-id 4E7A0D02.6050808@2ndQuadrant.com
обсуждение исходный текст
Ответ на Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace]  (Guillaume Cottenceau <gc@mnc.ch>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow query with self-join, group by, 100m rows
Следующее
От: Venkat Balaji
Дата:
Сообщение: Re: : Performance Improvement Strategy