Re: Table Bloat still there after the Vacuum

2010/4/26 akp geek <akpgeek(at)gmail(dot)com>:
> Hi All -
>                   I have a table bloated with following details
> rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB)
> *

I think this info come from check_postgres nagios script.
As said in the doc, this info is not 100% sure : it depend on the last
analyze *and* the type the columns *and* the distribution of data in
those columns.
I suggest you to check the pg_stats.avg_width relative to this table.

And, vacuum verbose information is good for diagnostics...

>                   I did  a vacuum on the database and also I did vacuumdb
> full on the table. Still there is no change. Can you please suggest if there
> is any other operation that can be done to take care of the issue
> Thanks for the help
>
> Regards

--
Cédric Villemain