What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0?
Is it still considered an important maintenance task? If so, how
frequently is it needed?

Ed


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Ed L. wrote:

7.4 at least handles a lot of the reindex issues at vacuum time.
I assume 8 does the same.

Sincerely,

Joshua D. Drake



--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd (AT) commandprompt (DOT) com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

EL> What is the conventional wisdom about routine reindexing with
EL> 7.4.6 and 8.0? Is it still considered an important maintenance
EL> task? If so, how frequently is it needed?

I haven't seen a need to reindex since upgrading from 7.2 to 7.4.
Under 7.2, I needed to reindex once per month or so.


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera (AT) kciLink (DOT) com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org