• Robert Haas's avatar
    Change the format of the VM fork to add a second bit per page. · a892234f
    Robert Haas authored
    The new bit indicates whether every tuple on the page is already frozen.
    It is cleared only when the all-visible bit is cleared, and it can be
    set only when we vacuum a page and find that every tuple on that page is
    both visible to every transaction and in no need of any future
    vacuuming.
    
    A future commit will use this new bit to optimize away full-table scans
    that would otherwise be triggered by XID wraparound considerations.  A
    page which is merely all-visible must still be scanned in that case, but
    a page which is all-frozen need not be.  This commit does not attempt
    that optimization, although that optimization is the goal here.  It
    seems better to get the basic infrastructure in place first.
    
    Per discussion, it's very desirable for pg_upgrade to automatically
    migrate existing VM forks from the old format to the new format.  That,
    too, will be handled in a follow-on patch.
    
    Masahiko Sawada, reviewed by Kyotaro Horiguchi, Fujii Masao, Amit
    Kapila, Simon Riggs, Andres Freund, and others, and substantially
    revised by me.
    a892234f
vacuumlazy.c 60.9 KB