Re: Index bloat of 4x

[Vivek Khera <vivek@xxxxxxxxx>]

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.

Attachment: smime.p7s
Description: S/MIME cryptographic signature