Toggle navigation

vacuum_multixact_freeze_min_age

Type: integer
Default: 5000000
Min: 0
Max: 1000000000
Context: user
Restart: false
Since: 9.3

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