• Robert Haas's avatar
    Teach autovacuum about multixact member wraparound. · 53bb309d
    Robert Haas authored
    The logic introduced in commit b69bf30b
    and repaired in commits 669c7d20 and
    7be47c56 helps to ensure that we don't
    overwrite old multixact member information while it is still needed,
    but a user who creates many large multixacts can still exhaust the
    member space (and thus start getting errors) while autovacuum stands
    idly by.
    
    To fix this, progressively ramp down the effective value (but not the
    actual contents) of autovacuum_multixact_freeze_max_age as member space
    utilization increases.  This makes autovacuum more aggressive and also
    reduces the threshold for a manual VACUUM to perform a full-table scan.
    
    This patch leaves unsolved the problem of ensuring that emergency
    autovacuums are triggered even when autovacuum=off.  We'll need to fix
    that via a separate patch.
    
    Thomas Munro and Robert Haas
    53bb309d
maintenance.sgml 44 KB