Add max_parallel_workers GUC.

Enterprise / PostgreSQL - Robert Haas [postgresql.org] - 2 December 2016 06:42 UTC

Increase the default value of the existing max_worker_processes GUC from 8 to 16, and add a new max_parallel_workers GUC with a maximum of 8. This way, even if the maximum amount of parallel query is happening, there is still room for background workers that do other things, as originally envisioned when max_worker_processes was added.

Julien Rouhaud, reviewed by Amit Kapila and by revised by me.

b460f5d Add max_parallel_workers GUC.
doc/src/sgml/config.sgml | 23 +++++++++++--
src/backend/access/transam/parallel.c | 3 +-
src/backend/postmaster/bgworker.c | 45 ++++++++++++++++++++++++-
src/backend/utils/init/globals.c | 3 +-
src/backend/utils/misc/guc.c | 12 ++++++-
src/backend/utils/misc/postgresql.conf.sample | 3 +-
src/bin/pg_resetxlog/pg_resetxlog.c | 4 +--
src/include/miscadmin.h | 1 +
src/include/postmaster/bgworker.h | 9 +++++
9 files changed, 93 insertions(+), 10 deletions(-)

Upstream: git.postgresql.org

  • Share