• Tom Lane's avatar
    Modify btree to delete known-dead index entries without an actual VACUUM. · e6284649
    Tom Lane authored
    When we are about to split an index page to do an insertion, first look
    to see if any entries marked LP_DELETE exist on the page, and if so remove
    them to try to make enough space for the desired insert.  This should reduce
    index bloat in heavily-updated tables, although of course you still need
    VACUUM eventually to clean up the heap.
    
    Junji Teramoto
    e6284649
nbtutils.c 31.5 KB