pgsql: Add max_parallel_workers GUC.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add max_parallel_workers GUC.
Date: 2016-12-02 12:45:34
Message-ID: E1cCnDa-0003Uh-0b@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Add max_parallel_workers GUC.

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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b460f5d6693103076dc554aa7cbb96e1e53074f9

Modified Files
--------------
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(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2016-12-02 13:19:38 pgsql: Fix outdated comments
Previous Message Alvaro Herrera 2016-12-02 12:42:25 Re: pgsql: Refactor libpqwalreceiver

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-12-02 12:45:56 Re: Rename max_parallel_degree?
Previous Message Petr Jelinek 2016-12-02 12:45:27 Re: Logical Replication WIP