PostgreSQL version:

vacuum_multixact_freeze_min_age

Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table. The default is 5 million multixacts. Although users can set this value anywhere from zero to one billion, VACUUM will silently limit the effective value to half the value of autovacuum_multixact_freeze_max_age, so that there is not an unreasonably short time between forced autovacuums. For more information see vacuum-for-multixact-wraparound.

Recommendations

Like freeze_min_age, lower this to somewhere around an hour of XID burn. Try starting with 500000.

Comments