Reindex database

[Greg Spiegelberg]

Any rule of thumb for REINDEX DATABASE? Once per month?
Per x transactions?
--
Greg Spiegelberg
Sr. Product Development Engineer
Cranel, Incorporated.
Phone: [phone]
Fax: [phone]
Email: ***@Cranel.com
Cranel. Technology. Integrity. Focus.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[scott.marlowe]

Post by Greg Spiegelberg
Any rule of thumb for REINDEX DATABASE? Once per month?
Per x transactions?

You shouldn't need to reindex databases for the most part. If there's
lots of catalog updates / delete, it might be occasionally useful to down
the database and reindex those catalogs in single user mode since you
can't reindex them on a live database if I remember correctly.

If you are running 7.3.5 or before, you might need to schedule daily /
weekly / monthly etc reindexes of indexes that show unreasonable growth
problems. This should be mostly fixed for 7.4, and reindexes should not
really be needed anymore, we hope :-).

generally speaking, reindex is for fixing broken indexes, not generaly
maintenance.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly