diff options
| author | Robert Haas <rhaas@postgresql.org> | 2016-12-02 07:42:58 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2016-12-02 07:42:58 -0500 |
| commit | b460f5d6693103076dc554aa7cbb96e1e53074f9 (patch) | |
| tree | 01fd17d21facc8d329936fb18ec554d41c39abf7 /src/backend/access/transam/parallel.c | |
| parent | 5714931b075b2dc8994b6e464ea3845c33ecf416 (diff) | |
| download | postgresql-b460f5d6693103076dc554aa7cbb96e1e53074f9.tar.gz postgresql-b460f5d6693103076dc554aa7cbb96e1e53074f9.zip | |
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.
Diffstat (limited to 'src/backend/access/transam/parallel.c')
| -rw-r--r-- | src/backend/access/transam/parallel.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/backend/access/transam/parallel.c b/src/backend/access/transam/parallel.c index 59dc3949d83..1c32fcd046c 100644 --- a/src/backend/access/transam/parallel.c +++ b/src/backend/access/transam/parallel.c @@ -454,7 +454,8 @@ LaunchParallelWorkers(ParallelContext *pcxt) snprintf(worker.bgw_name, BGW_MAXLEN, "parallel worker for PID %d", MyProcPid); worker.bgw_flags = - BGWORKER_SHMEM_ACCESS | BGWORKER_BACKEND_DATABASE_CONNECTION; + BGWORKER_SHMEM_ACCESS | BGWORKER_BACKEND_DATABASE_CONNECTION + | BGWORKER_CLASS_PARALLEL; worker.bgw_start_time = BgWorkerStart_ConsistentState; worker.bgw_restart_time = BGW_NEVER_RESTART; worker.bgw_main = ParallelWorkerMain; |