vacuum_truncate

Enables or disables vacuum to try to truncate off any empty pages at the end of the table. The default value is true. If true, VACUUM and autovacuum do the truncation and the disk space for the truncated pages is returned to the operating system. Note that the truncation requires an ACCESS EXCLUSIVE lock on the table. The TRUNCATE parameter of VACUUM, if specified, overrides the value of this parameter. The setting can also be overridden for individual tables by changing table storage parameters.

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

18 19 20

boot val: on
category: Vacuuming / Default Behavior
context: user
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: Unknown
metadata version: 18
min val: Unknown
name: vacuum_truncate
short desc: Enables vacuum to truncate empty pages at the end of the table.
source: pg-settings-source-snapshot
unit: Unknown
vartype: bool

Definition PG 18

Enables or disables vacuum to try to truncate off any empty pages at the end of the table. The default value is true. If true, VACUUM and autovacuum do the truncation and the disk space for the truncated pages is returned to the operating system. Note that the truncation requires an ACCESS EXCLUSIVE lock on the table. The TRUNCATE parameter of VACUUM, if specified, overrides the value of this parameter. The setting can also be overridden for individual tables by changing table storage parameters.

Compare versions

Complete source facts

doc html

<p>
         Enables or disables vacuum to try to truncate off any empty pages at
         the end of the table.  The default value is <code class="literal">true</code>.
         If <code class="literal">true</code>, <code class="command">VACUUM</code> and autovacuum
         do the truncation and the disk space for the truncated pages is
         returned to the operating system.  Note that the truncation requires
         an <code class="literal">ACCESS EXCLUSIVE</code> lock on the table.  The
         <code class="literal">TRUNCATE</code> parameter of
         <a class="link" href="/docs/18/sql-vacuum.html" title="VACUUM"><code class="command">VACUUM</code></a>, if
         specified, overrides the value of this parameter.  The setting can
         also be overridden for individual tables by changing table storage
         parameters.
        </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:1f461f53a473b28fc85061fafd66c98622732df9fac68369413cb84abc3cc1da

Text language: en · wiki-repair-20261023:1f461f53a473b28fc85061fafd66c98622732df9fac68369413cb84abc3cc1da