From 917bb870f9ef9d0d3e18dcf0fb6998e2ff4750ff Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Wed, 4 Nov 2015 06:24:40 -0500 Subject: [PATCH] Increase max_parallel_degree from 0 to 2. --- src/backend/optimizer/path/costsize.c | 2 +- src/backend/utils/misc/guc.c | 2 +- src/backend/utils/misc/postgresql.conf.sample | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/backend/optimizer/path/costsize.c b/src/backend/optimizer/path/costsize.c index 5fc80e735b..21505249b0 100644 --- a/src/backend/optimizer/path/costsize.c +++ b/src/backend/optimizer/path/costsize.c @@ -112,7 +112,7 @@ int effective_cache_size = DEFAULT_EFFECTIVE_CACHE_SIZE; Cost disable_cost = 1.0e10; -int max_parallel_degree = 0; +int max_parallel_degree = 2; bool enable_seqscan = true; bool enable_indexscan = true; diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 38ba82fe4b..d949c19ca2 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -2550,7 +2550,7 @@ static struct config_int ConfigureNamesInt[] = NULL }, &max_parallel_degree, - 0, 0, MAX_BACKENDS, + 2, 0, MAX_BACKENDS, NULL, NULL, NULL }, diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 029114fc22..930628c33b 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -164,7 +164,7 @@ #effective_io_concurrency = 1 # 1-1000; 0 disables prefetching #max_worker_processes = 8 -#max_parallel_degree = 0 # max number of worker processes per node +#max_parallel_degree = 2 # max number of worker processes per node #------------------------------------------------------------------------------ -- 2.39.5