when to reindex? - Mailing list pgsql-general

From Roberts, Jon
Subject when to reindex?
Date
Msg-id 1A6E6D554222284AB25ABE3229A92762E9A49F@nrtexcus702.int.asurion.com
Whole thread Raw
Responses Re: when to reindex?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
In Oracle, there is a method to determine when it is advisable to
rebuild indexes.  Are there any guidelines for this in PostgreSQL?

I found this but it doesn't indicate at which point an index should be
rebuilt other than corruption.

http://www.postgresql.org/docs/8.3/interactive/routine-reindex.html



Jon

pgsql-general by date:

Previous
From: "Ken Winter"
Date:
Subject: Re: Extracting data from deprecated MONEY fields
Next
From: Adrian Klaver
Date:
Subject: Re: Extracting data from deprecated MONEY fields