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

Reply via email to