Some time ago I reported a problem where right after an index rebuild vacuum
might take a couple of hours, but gets slower and slower at a seeming
increasing rate as time goes on. What takes a couple of ours after a full
index rebuild now takes 12 hours or more.
The problem was determined to be due to the fact that indexes are vacuumed
in index order, not in disk storage order. I don't see anything about this
in the "What's new" for 8.1. Has anything been done to resolve this?
Scheduled index rebuilds are not feasible. I really don't even want to take
a chance on starting one. The database is just a hair under one billion
rows, and could take the entire weekend or more to rebuild.
Wes