Disagree. We only apply reindex on tables that see lots of updates...
With our 7.4.x databases we vacuum each day, but we see real performance gains after re-indexing too - we see lower load averages and no decrease in responsiveness over time. Plus we have the benefit of reduced disk space usage.
I think that the two things go hand in hand, although vacuum is the most important.
John Jim C. Nasby wrote:
And if you're vacuuming frequently enough, there shouldn't be that much need to reindex.
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
