Re: REINDEX not working for wastedspace - Mailing list 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