On Jan 17, 2007, at 11:56 AM, Tom Lane wrote:
> So the above doesn't sound too unlikely. Perhaps we should recommend
> vac full + reindex as standard cleanup procedure. Longer term, maybe
> teach vac full to do an automatic reindex if it's moved more than X
> % of
a vac full + reindex is a waste of effort.
whenever i need a big cleanup, I drop indexes (other than PK), vac
full, re-create indexes.
however, usually a reindex does a sufficient job if vacuum has been
run with any sort of regularity.