when to reindex?

by Jon.Roberts@[EMAIL PROTECTED] ("Roberts, Jon") Jun 6, 2008 at 10:36 AM

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

--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

8 Posts in Topic:

when to reindex?

Jon.Roberts@[EMAIL PROTEC

2008-06-06 10:36:01

Re: when to reindex?

scott.marlowe@[EMAIL PROT

2008-06-06 11:01:24

Re: when to reindex?

Jon.Roberts@[EMAIL PROTEC

2008-06-06 13:02:58

Re: when to reindex?

hunteke@[EMAIL PROTECTED]