| 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 trigger freezing of pages with an older multixact ID. 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.