Postgres Pro
Downloads
Home   >   mailing lists

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

From DM
Subject Re: Fragmentation/Vacuum, Analyze, Re-Index
Date
Msg-id eae6a62a1001220910t7bbb8c1bseaf2c0aec62b7bb9@mail.gmail.com
Whole thread Raw
In response to Fragmentation/Vacuum, Analyze, Re-Index  (DM <dm.aeqa@gmail.com>)
Responses Re: Fragmentation/Vacuum, Analyze, Re-Index  (Richard Neill <rn214@cam.ac.uk>)
List pgsql-performance
Tree view
Is there any script/tool to identify if the table requires full vacuum? or to re-index an existing index table?

Thanks
Deepak

On Fri, Jan 22, 2010 at 12:11 AM, DM <dm.aeqa@gmail.com> wrote:
Hello All,

How to identify if a table requires full vacuum? How to identify when to do re-index on an existing index of a table?

Is there any tool for the above?

Thanks
Deepak Murthy



pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Slow update query
Next
From: "Carlo Stonebanks"
Date:
Subject: Re: New server to improve performance on our large and busy DB - advice?