autovacuum_max_workers

Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is 3. This parameter can only be set in the postgresql.conf file or on the server command line. Note that a setting for this value which is higher than autovacuum_worker_slots will have no effect, since autovacuum workers are taken from the pool of slots established by that setting.

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.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: 3
category: Vacuuming / Automatic Vacuuming
context: sighup
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: 262143
metadata version: 18
min val: 1
name: autovacuum_max_workers
short desc: Sets the maximum number of simultaneously running autovacuum worker processes.
source: pg-settings-source-snapshot
unit: Unknown
vartype: integer

Definition PG 18

Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is 3. This parameter can only be set in the postgresql.conf file or on the server command line.

Note that a setting for this value which is higher than autovacuum_worker_slots will have no effect, since autovacuum workers are taken from the pool of slots established by that setting.

Compare versions

Complete source facts

doc html

<p>
         Specifies the maximum number of autovacuum processes (other than the
         autovacuum launcher) that may be running at any one time.  The default
         is <code class="literal">3</code>.  This parameter can only be set in the
         <code class="filename">postgresql.conf</code> file or on the server command line.
        </p><p>
         Note that a setting for this value which is higher than
         <a class="xref" href="/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM-WORKER-SLOTS">autovacuum_worker_slots</a> will have no effect,
         since autovacuum workers are taken from the pool of slots established
         by that setting.
        </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:c86528ebe468fe302a937e9f7b922b4233d5cb6af7facf628c59b9f80209016f

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