On Fri, 12 Dec 2003, Greg Spiegelberg wrote:
> 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
In response to
pgsql-admin by date
|Next:||From: Sai Hertz And Control Systems||Date: 2003-12-12 16:06:08|
|Subject: Tables Without OIDS and its effect|
|Previous:||From: scott.marlowe||Date: 2003-12-12 15:48:14|
|Subject: Re: ODBC Driver generates a too big "windows swap file" and|