Wiki / Configuration Parameters
max_parallel_workers
Sets the maximum number of workers that the cluster can support for parallel operations. The default value is 8. When increasing or decreasing this value, consider also adjusting max_parallel_maintenance_workers and max_parallel_workers_per_gather. Also, note that a setting for this value which is higher than max_worker_processes will have no effect, since parallel workers are taken from the pool of worker processes 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
- boot val
- 8
- category
- Resource Usage / Worker Processes
- context
- user
- documented
- true
- enumvals
- Unknown
- extra desc
- Unknown
- lang
- en
- max val
- 1024
- metadata version
- 18
- min val
- 0
- name
- max_parallel_workers
- short desc
- Sets the maximum number of parallel workers that can be active at one time.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- integer
Definition PG 18
Sets the maximum number of workers that the cluster can support for parallel operations. The default value is 8. When increasing or decreasing this value, consider also adjusting max_parallel_maintenance_workers and max_parallel_workers_per_gather. Also, note that a setting for this value which is higher than max_worker_processes will have no effect, since parallel workers are taken from the pool of worker processes established by that setting.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:10b8d168ec5bfbc98038a5d79699033090afcd5d95cc882e1d39ba4f12b91bf1
Text language: en · wiki-repair-20261023:10b8d168ec5bfbc98038a5d79699033090afcd5d95cc882e1d39ba4f12b91bf1