autovacuum_vacuum_insert_scale_factor

Specifies a fraction of the unfrozen pages in the table to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of unfrozen pages in table). 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

13 14 15 16 17 18 19 20

boot val: 0.2
category: Vacuuming / Automatic Vacuuming
context: sighup
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: 100
metadata version: 18
min val: 0
name: autovacuum_vacuum_insert_scale_factor
short desc: Number of tuple inserts prior to vacuum as a fraction of reltuples.
source: pg-settings-source-snapshot
unit: Unknown
vartype: real

Definition PG 18

Specifies a fraction of the unfrozen pages in the table to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of unfrozen pages in table). 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 a fraction of the unfrozen pages in the table to add to
         <code class="varname">autovacuum_vacuum_insert_threshold</code> when deciding
         whether to trigger a <code class="command">VACUUM</code>. The default is
         <code class="literal">0.2</code> (20% of unfrozen pages in table). 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:c812894fd5a4fc1691311413d1423d7f2fb283f9cd12204d77068a1c88fe4c23

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