autovacuum and reindex

From: Joao Miguel Ferreira <joao(dot)mc(dot)ferreira(at)criticalsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: autovacuum and reindex
Date: 2007-11-14 11:28:46
Message-ID: 1195039726.3983.19.camel@azagthot.critical.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I'd like to know if the autovacuum feature also deals with automatically
reindexing my indexes.

I know Pg8 know comes with a more eficient management of indexes, but I
also read in the manuals that it's still good practice to routine
reindex de most critical (in terms of speed) indexes.

Could someone please tell me if autovacuum does or doesnt take care of
reindexing, or if reindexing is or isn't important in pg8.

thx++;

Joao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-11-14 11:48:03 Re: autovacuum and reindex
Previous Message Martijn van Oosterhout 2007-11-14 10:36:16 Re: Client-requested cast mode to emulate Pg8.2 on v8.3