On Tue, Dec 06, 2005 at 04:03:22PM -0600, Ameet Kini wrote:
>I'm running postgresql v8.0 and my problem is that running vacuum on my
>indices are blazing fast (upto 10x faster) AFTER running reindex. For a
>table with only 1 index, the time to do a vacuum (without full) went down
>from 45 minutes to under 3 minutes.
I've also noticed a fairly large increase in vacuum speed after a
reindex. (To the point where the reindex + vacuum was faster than just a
vacuum.)
Mike Stone