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/utils/init/globals.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/utils/init/globals.c')
| -rw-r--r-- | src/backend/utils/init/globals.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/backend/utils/init/globals.c b/src/backend/utils/init/globals.c index f23208353c3..c564ae396da 100644 --- a/src/backend/utils/init/globals.c +++ b/src/backend/utils/init/globals.c @@ -121,7 +121,8 @@ int replacement_sort_tuples = 150000; */ int NBuffers = 1000; int MaxConnections = 90; -int max_worker_processes = 8; +int max_worker_processes = 16; +int max_parallel_workers = 8; int MaxBackends = 0; int VacuumCostPageHit = 1; /* GUC parameters for vacuum */ |