Re: Fragmentation/Vacuum, Analyze, Re-Index

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

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(dot)aeqa(at)gmail(dot)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
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2010-01-22 17:12:42 Re: more docs on extending postgres in C
Previous Message DM 2010-01-22 17:09:26 Re: When is the release date for Postgres 8.5?

Browse pgsql-performance by date

  From Date Subject
Next Message Carlo Stonebanks 2010-01-22 17:37:56 Re: New server to improve performance on our large and busy DB - advice?
Previous Message Robert Haas 2010-01-22 15:05:38 Re: Slow update query