Fragmentation/Vacuum, Analyze, Re-Index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx, pgsql-general@xxxxxxxxxxxxxx
Subject: Fragmentation/Vacuum, Analyze, Re-Index
From: DM <dm.aeqa@xxxxxxxxx>
Date: Fri, 22 Jan 2010 00:11:37 -0800

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

Follow-Ups:
- Re: Fragmentation/Vacuum, Analyze, Re-Index
  - From: DM

Prev by Date: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Next by Date: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Previous by thread: TPC-C implementation for postgresql?
Next by thread: Re: Fragmentation/Vacuum, Analyze, Re-Index
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux