On 1/22/2010 2:27 PM, Richard Neill wrote:
> DM wrote:
>> Is there any script/tool to identify if the table requires full
>> vacuum? or to re-index an existing index table?
http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html
The bucardo project has released its nagios plugins for PostgreSQL and we can extract from them this nice view
in order to check for table and index bloat into our PostgreSQL databases: