when to reindex?

From: "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
To: "Pgsql General list" <pgsql-general(at)postgresql(dot)org>
Subject: when to reindex?
Date: 2008-06-06 15:36:01
Message-ID: 1A6E6D554222284AB25ABE3229A92762E9A49F@nrtexcus702.int.asurion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2008-06-06 15:49:11 Re: Extracting data from deprecated MONEY fields
Previous Message Ken Winter 2008-06-06 15:25:44 Re: Extracting data from deprecated MONEY fields