On Tue, Jan 6, 2009 at 9:05 AM, Grzegorz Jaśkiewicz <gryzman@gmail.com> wrote:
> you don't have to reindex too often - it locks exclusively whole
> table, just like vacuum full. Just do it every few months, depending
> on db growth.
While I don't wholly disagree with periodic reindexing, I do recommend
that one keeps track of bloat. It's easy enough to have an alarm that
goes off if any index gets over 50% dead space, then go look at the
database. Or go in every week and see what vacuum verbose looks like.
Even if you just email yourself a copy of the last 10 or 15 lines
every morning or something to see how bloated the db is in general,
you'll catch most problems before they become problems. One or two
rogue updates without where clauses on medium to large sized tables
can blow you right out of the water. Best to have some way to keep
track of them.