vacuum_freeze_table_age

doc html

<p>
<code class="command">VACUUM</code> performs an aggressive scan if the table's
         <code class="structname">pg_class</code>.<code class="structfield">relfrozenxid</code> field has reached
         the age specified by this setting.  An aggressive scan differs from
         a regular <code class="command">VACUUM</code> in that it visits every page that might
         contain unfrozen XIDs or MXIDs, not just those that might contain dead
         tuples.  The default is 150 million transactions.  Although users can
         set this value anywhere from zero to two billion, <code class="command">VACUUM</code>
         will silently limit the effective value to 95% of
         <a class="xref" href="/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM-FREEZE-MAX-AGE">autovacuum_freeze_max_age</a>, so that a
         periodic manual <code class="command">VACUUM</code> has a chance to run before an
         anti-wraparound autovacuum is launched for the table. For more
         information see
         <a class="xref" href="/docs/18/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND" title="24.1.5. Preventing Transaction ID Wraparound Failures">Section 24.1.5</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"}