diff options
| author | Robert Haas <rhaas@postgresql.org> | 2016-08-16 08:09:15 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2016-08-16 08:09:15 -0400 |
| commit | f85b1a84152f7bf019fd7a2c5eede97867dcddbb (patch) | |
| tree | 5bd69a379fa7734d0f4a9275edac2ea6f54d86c5 /src | |
| parent | b5bce6c1ec6061c8a4f730d927e162db7e2ce365 (diff) | |
| download | postgresql-f85b1a84152f7bf019fd7a2c5eede97867dcddbb.tar.gz postgresql-f85b1a84152f7bf019fd7a2c5eede97867dcddbb.zip | |
Disable parallel query by default.
Per discussion, set the default value of max_parallel_workers_per_gather
to 0 in 9.6 only. We'll leave it enabled in master so that it gets
more testing and in the hope that it can be enable by default in v10.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/optimizer/path/costsize.c | 2 | ||||
| -rw-r--r-- | src/backend/utils/misc/guc.c | 2 | ||||
| -rw-r--r-- | 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 2a49639f125..4ad1782bbf7 100644 --- a/src/backend/optimizer/path/costsize.c +++ b/src/backend/optimizer/path/costsize.c @@ -113,7 +113,7 @@ int effective_cache_size = DEFAULT_EFFECTIVE_CACHE_SIZE; Cost disable_cost = 1.0e10; -int max_parallel_workers_per_gather = 2; +int max_parallel_workers_per_gather = 0; 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 9c93df0f0a4..0a58ba1faeb 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -2652,7 +2652,7 @@ static struct config_int ConfigureNamesInt[] = NULL }, &max_parallel_workers_per_gather, - 2, 0, 1024, + 0, 0, 1024, NULL, NULL, NULL }, diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 6d0666c44fc..9644a667ff8 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -163,7 +163,7 @@ #effective_io_concurrency = 1 # 1-1000; 0 disables prefetching #max_worker_processes = 8 # (change requires restart) -#max_parallel_workers_per_gather = 2 # taken from max_worker_processes +#max_parallel_workers_per_gather = 0 # taken from max_worker_processes #old_snapshot_threshold = -1 # 1min-60d; -1 disables; 0 is immediate # (change requires restart) #backend_flush_after = 0 # 0 disables, default is 0 |