Fragmentation/Vacuum, Analyze, Re-Index

From: DM <dm(dot)aeqa(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Fragmentation/Vacuum, Analyze, Re-Index
Date: 2010-01-22 08:11:37
Message-ID: eae6a62a1001220011u4209f123yb7e1b6f8fe8fd757@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2010-01-22 08:13:10 Re: When is the release date for Postgres 8.5?
Previous Message DM 2010-01-22 08:07:05 When is the release date for Postgres 8.5?

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2010-01-22 09:42:49 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Previous Message Craig Ringer 2010-01-22 03:46:07 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL