• Simon Riggs's avatar
    Respect Hot Standby controls while recycling btree index pages. · 758bd2a4
    Simon Riggs authored
    Btree pages were recycled after VACUUM deletes all records on a
    page and then a subsequent VACUUM occurs after the RecentXmin
    horizon is reached. Using RecentXmin meant that we did not respond
    correctly to the user controls provide to avoid Hot Standby
    conflicts and so spurious conflicts could be generated in some
    workload combinations. We now reuse pages only when we reach
    RecentGlobalXmin, which can be much later in the presence of long
    running queries and is also controlled by vacuum_defer_cleanup_age
    and hot_standby_feedback.
    
    Noah Misch and Simon Riggs
    758bd2a4
nbtpage.c 45.2 KB