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.