On Oct 27, 2006, at 2:07 PM, Tom Lane wrote:
8.2, but in existing releases I can't see much you can do about it except REINDEX when things get slow.
This will be so nice for me. I have one huge table with a massive amount of churn and bulk deletes. I have to reindex it once every other month. It takes about 60 to 75 minutes per index (times two indexes) else I'd do it monthly.
It shaves nearly 1/3 of the relpages off of the index size.
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
