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, maybeteach 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.
smime.p7s
Description: S/MIME cryptographic signature
