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
In response to
pgsql-performance by date
|Next:||From: Guillaume Cottenceau||Date: 2011-09-21 12:43:07|
|Subject: Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace]|
|Previous:||From: AI Rumman||Date: 2011-09-21 07:10:30|
|Subject: Re: REINDEX not working for wastedspace|