Re: REINDEX not working for wastedspace

Поиск
Список
Период
Сортировка
От Reid Thompson
Тема Re: REINDEX not working for wastedspace
Дата
Msg-id 1316607691.17526.60.camel@raker.ateb.com
обсуждение исходный текст
Ответ на REINDEX not working for wastedspace  (AI Rumman <rummandba@gmail.com>)
Список pgsql-performance
On Wed, 2011-09-21 at 13:01 +0600, AI Rumman wrote:
> I am using Postgresql 9.0.1.
>

> I REINDEXED  both the indexes and table, but I did not find any change
> in wastedspace or wastedispace.
> Could you please tell me why?

you need to

1) either vacuum full or cluster the table
2) analyze the table
3) check bloat again


В списке pgsql-performance по дате отправления: