Re: Importance of re-index

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.