Re: Fragmentation/Vacuum, Analyze, Re-Index - Mailing list pgsql-performance

From Reid Thompson
Subject Re: Fragmentation/Vacuum, Analyze, Re-Index
Date
Msg-id 4B5A97EB.3010800@ateb.com
Whole thread Raw
In response to Re: Fragmentation/Vacuum, Analyze, Re-Index  (Richard Neill <rn214@cam.ac.uk>)
List pgsql-performance
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:

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Next
From: "ramasubramanian"
Date:
Subject: Sql result b where condition