autovacuum and reindex - Mailing list pgsql-general

From Joao Miguel Ferreira
Subject autovacuum and reindex
Date
Msg-id 1195039726.3983.19.camel@azagthot.critical.pt
Whole thread Raw
Responses Re: autovacuum and reindex  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List 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




pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Client-requested cast mode to emulate Pg8.2 on v8.3
Next
From: Alvaro Herrera
Date:
Subject: Re: autovacuum and reindex