• T
    Rewrite btree vacuuming to fold the former bulkdelete and cleanup operations · 5749f6ef
    Tom Lane 提交于
    into a single mostly-physical-order scan of the index.  This requires some
    ticklish interlocking considerations, but should create no material
    performance impact on normal index operations (at least given the
    already-committed changes to make scans work a page at a time).  VACUUM
    itself should get significantly faster in any index that's degenerated to a
    very nonlinear page order.  Also, we save one pass over the index entirely,
    except in the case where there were no deletions to do and so only one pass
    happened anyway.
    
    Original patch by Heikki Linnakangas, rework by Tom Lane.
    5749f6ef
nbtree.h 20.2 KB