| From: | Reid Thompson <reid(dot)thompson(at)ateb(dot)com> |
|---|---|
| To: | Richard Neill <rn214(at)cam(dot)ac(dot)uk> |
| Cc: | DM <dm(dot)aeqa(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Fragmentation/Vacuum, Analyze, Re-Index |
| Date: | 2010-01-23 06:32:11 |
| Message-ID: | 4B5A97EB.3010800@ateb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaśkiewicz | 2010-01-23 07:24:06 | Re: What locking mechanism is used for database backup and restore and Master-Slave Replication? |
| Previous Message | Pavel Stehule | 2010-01-23 04:46:06 | Re: Variadic polymorpic functions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ramasubramanian | 2010-01-25 09:36:25 | Sql result b where condition |
| Previous Message | Scott Carey | 2010-01-23 03:31:00 | Re: Inserting 8MB bytea: just 25% of disk perf used? |