autovacuum_vacuum_cost_delay

Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. If this value is specified without units, it is taken as milliseconds. The default value is 2 milliseconds. 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: 2
category: Vacuuming / Automatic Vacuuming
context: sighup
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: -1 means use "vacuum_cost_delay".
lang: en
max val: 100
metadata version: 18
min val: -1
name: autovacuum_vacuum_cost_delay
short desc: Vacuum cost delay in milliseconds, for autovacuum.
source: pg-settings-source-snapshot
unit: ms
vartype: real

Definition PG 18

Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. If this value is specified without units, it is taken as milliseconds. The default value is 2 milliseconds. 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 cost delay value that will be used in automatic
         <code class="command">VACUUM</code> operations.  If -1 is specified, the regular
         <a class="xref" href="/docs/18/runtime-config-vacuum.html#GUC-VACUUM-COST-DELAY">vacuum_cost_delay</a> value will be used.
         If this value is specified without units, it is taken as milliseconds.
         The default value is 2 milliseconds.
         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:de6709603069da9de41e19572ea9be4371eb25d65d1da5ac36d70eba0bd63df0

Text language: en · wiki-repair-20261023:de6709603069da9de41e19572ea9be4371eb25d65d1da5ac36d70eba0bd63df0