↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

vacuum_cost_delay

The amount of time that the process will sleep when the cost limit has been exceeded. If this value is specified without units, it is taken as milliseconds. The default value is 0, which disables the cost-based vacuum delay feature. Positive values enable cost-based vacuuming. When using cost-based vacuuming, appropriate values for vacuum_cost_delay are usually quite small, perhaps less than 1 millisecond. While vacuum_cost_delay can be set to fractional-millisecond values, such delays may not be measured accurately on older platforms. On such platforms, increasing VACUUM's throttled resource consumption above what you get at 1ms will require changing the other vacuum cost parameters. You should, nonetheless, keep vacuum_cost_delay as small as your platform will consistently measure; large delays are not helpful.

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

boot val
0
category
Vacuuming / Cost-Based Vacuum Delay
context
user
doc same as
Unknown
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
100
metadata version
18
min val
0
name
vacuum_cost_delay
short desc
Vacuum cost delay in milliseconds.
source
pg-settings-source-snapshot
unit
ms
vartype
real

Definition PG 18

The amount of time that the process will sleep when the cost limit has been exceeded. If this value is specified without units, it is taken as milliseconds. The default value is 0, which disables the cost-based vacuum delay feature. Positive values enable cost-based vacuuming.

When using cost-based vacuuming, appropriate values for vacuum_cost_delay are usually quite small, perhaps less than 1 millisecond. While vacuum_cost_delay can be set to fractional-millisecond values, such delays may not be measured accurately on older platforms. On such platforms, increasing VACUUM's throttled resource consumption above what you get at 1ms will require changing the other vacuum cost parameters. You should, nonetheless, keep vacuum_cost_delay as small as your platform will consistently measure; large delays are not helpful.

Compare versions

Complete source facts

doc html

<p>
         The amount of time that the process will sleep when the cost
         limit has been exceeded. If this value is specified without
         units, it is taken as milliseconds. The default value is
         <code class="literal">0</code>, which disables the cost-based vacuum delay
         feature.  Positive values enable cost-based vacuuming.
        </p><p>
         When using cost-based vacuuming, appropriate values for
         <code class="varname">vacuum_cost_delay</code> are usually quite small, perhaps
         less than 1 millisecond.  While <code class="varname">vacuum_cost_delay</code>
         can be set to fractional-millisecond values, such delays may not be
         measured accurately on older platforms.  On such platforms,
         increasing <code class="command">VACUUM</code>'s throttled resource consumption
         above what you get at 1ms will require changing the other vacuum cost
         parameters.  You should, nonetheless,
         keep <code class="varname">vacuum_cost_delay</code> as small as your platform
         will consistently measure; large delays are not helpful.
        </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

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:b47d8d1ec79e62bdbeb9f1477900f64f98399b8435f754be46528569874d033a

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