Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitf85b1a8

Browse files
committed
Disable parallel query by default.
Per discussion, set the default value of max_parallel_workers_per_gatherto 0 in 9.6 only. We'll leave it enabled in master so that it getsmore testing and in the hope that it can be enable by default in v10.
1 parentb5bce6c commitf85b1a8

File tree

4 files changed

+4
-4
lines changed

4 files changed

+4
-4
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2008,7 +2008,7 @@ include_dir 'conf.d'
20082008
<xref linkend="guc-max-worker-processes">. Note that the requested
20092009
number of workers may not actually be available at run time. If this
20102010
occurs, the plan will run with fewer workers than expected, which may
2011-
be inefficient.The default value is 2.Setting this value to 0
2011+
be inefficient. Setting this value to 0, which is the default,
20122012
disables parallel query execution.
20132013
</para>
20142014

‎src/backend/optimizer/path/costsize.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -113,7 +113,7 @@ inteffective_cache_size = DEFAULT_EFFECTIVE_CACHE_SIZE;
113113

114114
Costdisable_cost=1.0e10;
115115

116-
intmax_parallel_workers_per_gather=2;
116+
intmax_parallel_workers_per_gather=0;
117117

118118
boolenable_seqscan= true;
119119
boolenable_indexscan= true;

‎src/backend/utils/misc/guc.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2652,7 +2652,7 @@ static struct config_int ConfigureNamesInt[] =
26522652
NULL
26532653
},
26542654
&max_parallel_workers_per_gather,
2655-
2,0,1024,
2655+
0,0,1024,
26562656
NULL,NULL,NULL
26572657
},
26582658

‎src/backend/utils/misc/postgresql.conf.sample

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -163,7 +163,7 @@
163163

164164
#effective_io_concurrency = 1# 1-1000; 0 disables prefetching
165165
#max_worker_processes = 8# (change requires restart)
166-
#max_parallel_workers_per_gather =2# taken from max_worker_processes
166+
#max_parallel_workers_per_gather =0# taken from max_worker_processes
167167
#old_snapshot_threshold = -1# 1min-60d; -1 disables; 0 is immediate
168168
# (change requires restart)
169169
#backend_flush_after = 0# 0 disables, default is 0

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp