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:
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
