Type: integer
Default: 8
Min: 0
Max: 1024
Context: user
Restart: false
Since: 10

Sets the maximum number of workers that the system 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.

Recommendations

… if you think you can benefit from parallel query, and even cores/1 for DW systems.

Comments