pgconfigurator
pgconfigurator

max_worker_processes

Requires a restarttuned by pgconfiguratorcount (background processes)

The hard ceiling on all background worker processes (parallelism, replication, extensions).

What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded

What it does

This is the absolute cap on background worker processes the cluster can run — parallel query workers, logical replication workers, and extension workers all come out of it. max_parallel_workers can't exceed it.

How to tune it

Keep it at least as large as max_parallel_workers plus the workers your extensions and logical replication need, with headroom. It's the one in this trio that requires a restart, so set it generously enough to raise the others later without one.

Related parameters