max_parallel_workers

A GUC determining the maximum number of workers available for parallel operations

max_parallel_workers is a GUC determining the maximum number of workers which are available for parallel query operations.

max_parallel_workers was added in PostgreSQL 10 (commit b460f5d6).

Default

The default value for max_parallel_workers is 8.

Categories

Background worker, GUC configuration item, Performance

See also

max_parallel_maintenance_workers, max_parallel_workers_per_gather, max_worker_processes