autovacuum_vacuum_threshold

Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples. This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can 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

8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

boot val: 50
category: Vacuuming / Automatic Vacuuming
context: sighup
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: 2147483647
metadata version: 18
min val: 0
name: autovacuum_vacuum_threshold
short desc: Minimum number of tuple updates or deletes prior to vacuum.
source: pg-settings-source-snapshot
unit: Unknown
vartype: integer

Definition PG 18

Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples. This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters.

Compare versions

Complete source facts

doc html

<p>
         Specifies the minimum number of updated or deleted tuples needed
         to trigger a <code class="command">VACUUM</code> in any one table.
         The default is 50 tuples.
         This parameter can only be set in the <code class="filename">postgresql.conf</code>
         file or on the server command line;
         but the setting can 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:6a4bbdd2e0874516b0323a95bf3bae6e849045cee7b06061b02c0f968630cfde

Text language: en · wiki-repair-20261023:6a4bbdd2e0874516b0323a95bf3bae6e849045cee7b06061b02c0f968630cfde