Re: REINDEX not working for wastedspace

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: REINDEX not working for wastedspace
Дата
Msg-id 22059.1316614372@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: REINDEX not working for wastedspace  (Shaun Thomas <sthomas@peak6.com>)
Ответы Re: REINDEX not working for wastedspace
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: : Performance Improvement Strategy
Следующее
От: Andy Lester
Дата:
Сообщение: Re: REINDEX not working for wastedspace