Markus Benne <thing(at)m-bass(dot)com> writes:
> Our table in question is vacuumed every 4 minutes, and
> we are reindexing after each one.
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