Markus Benne <[EMAIL PROTECTED]> writes: > Our table in question is vacuumed every 4 minutes, and > we are reindexing after each one.
Advertising
That's pretty silly. You might need a reindex once in awhile, but not every time you vacuum. The draft 8.1 docs contain some discussion of possible reasons for periodic reindexing: http://developer.postgresql.org/docs/postgres/routine-reindex.html but none of these reasons justify once-per-vacuum reindexes. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
