vacuum_multixact_freeze_min_age

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 Section 24.1.5.1.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

boot val: 5000000
category: Vacuuming / Freezing
context: user
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: 1000000000
metadata version: 18
min val: 0
name: vacuum_multixact_freeze_min_age
short desc: Minimum age at which VACUUM should freeze a MultiXactId in a table row.
source: pg-settings-source-snapshot
unit: Unknown
vartype: integer

Definition PG 18

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 Section 24.1.5.1.

Compare versions

Complete source facts

doc html

<p>
         Specifies the cutoff age (in multixacts) that <code class="command">VACUUM</code>
         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,
         <code class="command">VACUUM</code> will silently limit the effective value to half
         the value of <a class="xref" href="/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM-MULTIXACT-FREEZE-MAX-AGE">autovacuum_multixact_freeze_max_age</a>,
         so that there is not an unreasonably short time between forced
         autovacuums.
         For more information see <a class="xref" href="/docs/18/routine-vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND" title="24.1.5.1. Multixacts and Wraparound">Section 24.1.5.1</a>.
        </p>

documentation revision

{"inputs":[{"file":"runtime-config-vacuum.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"599d3819c5fa60f160ba633df604ee9afd85549ffad2ae2fb0c3132a00d47417","version":"18.7"},{"file":"runtime-config-vacuum.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"b835e4b6c446cfdaf673750aba29ba28fc55ef6cc0c531558c1e394fdc05a140","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:178c679bfe9214470ed0df2cfb973d21af580a6e2b92c58783ed58212d5f7f3b

Text language: en · wiki-repair-20261023:178c679bfe9214470ed0df2cfb973d21af580a6e2b92c58783ed58212d5f7f3b