• Peter Geoghegan's avatar
    VACUUM VERBOSE: Count "newly deleted" index pages. · 23763618
    Peter Geoghegan authored
    Teach VACUUM VERBOSE to report on pages deleted by the _current_ VACUUM
    operation -- these are newly deleted pages.  VACUUM VERBOSE continues to
    report on the total number of deleted pages in the entire index (no
    change there).  The former is a subset of the latter.
    
    The distinction between each category of deleted index page only arises
    with index AMs where page deletion is supported and is decoupled from
    page recycling for performance reasons.
    
    This is follow-up work to commit e5d8a999, which made nbtree store
    64-bit XIDs (not 32-bit XIDs) in pages at the point at which they're
    deleted.  Note that the btm_last_cleanup_num_delpages metapage field
    added by that commit usually gets set to pages_newly_deleted.  The
    exceptions (the scenarios in which they're not equal) all seem to be
    tricky cases for the implementation (of page deletion and recycling) in
    general.
    
    Author: Peter Geoghegan <pg@bowt.ie>
    Discussion: https://postgr.es/m/CAH2-WznpdHvujGUwYZ8sihX%3Dd5u-tRYhi-F4wnV2uN2zHpMUXw%40mail.gmail.com
    23763618
nbtree.c 46.9 KB