• Noah Misch's avatar
    Change XID and mxact limits to warn at 40M and stop at 3M. · cd5e8225
    Noah Misch authored
    We have edge-case bugs when assigning values in the last few dozen pages
    before the wrap limit.  We may introduce similar bugs in the future.  At
    default BLCKSZ, this makes such bugs unreachable outside of single-user
    mode.  Also, when VACUUM began to consume mxacts, multiStopLimit did not
    change to compensate.
    
    pg_upgrade may fail on a cluster that was already printing "must be
    vacuumed" warnings.  Follow the warning's instructions to clear the
    warning, then run pg_upgrade again.  One can still, peacefully consume
    98% of XIDs or mxacts, so DBAs need not change routine VACUUM settings.
    
    Discussion: https://postgr.es/m/20200621083513.GA3074645@rfd.leadboat.com
    cd5e8225
maintenance.sgml 49.5 KB