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

Commit2b959d4

Browse files
committed
Reduce the default for max_worker_processes back to 8.
Commitb460f5d -- at my suggestion --increased the default value of max_worker_processes from 8 to 16, onthe theory that this would be harmless and convenient for users.Unfortunately, this caused some buildfarm machines with low connectionlimits to start failing, so apparently it's not harmless after all.
1 parent88f626f commit2b959d4

File tree

5 files changed

+6
-6
lines changed

5 files changed

+6
-6
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1982,7 +1982,7 @@ include_dir 'conf.d'
19821982
<para>
19831983
Sets the maximum number of background processes that the system
19841984
can support. This parameter can only be set at server start. The
1985-
default is16.
1985+
default is8.
19861986
</para>
19871987

19881988
<para>

‎src/backend/utils/init/globals.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -121,7 +121,7 @@ intreplacement_sort_tuples = 150000;
121121
*/
122122
intNBuffers=1000;
123123
intMaxConnections=90;
124-
intmax_worker_processes=16;
124+
intmax_worker_processes=8;
125125
intmax_parallel_workers=8;
126126
intMaxBackends=0;
127127

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

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2477,7 +2477,7 @@ static struct config_int ConfigureNamesInt[] =
24772477
NULL,
24782478
},
24792479
&max_worker_processes,
2480-
16,0,MAX_BACKENDS,
2480+
8,0,MAX_BACKENDS,
24812481
check_max_worker_processes,NULL,NULL
24822482
},
24832483

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

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -161,7 +161,7 @@
161161
# - Asynchronous Behavior -
162162

163163
#effective_io_concurrency = 1# 1-1000; 0 disables prefetching
164-
#max_worker_processes =16# (change requires restart)
164+
#max_worker_processes =8# (change requires restart)
165165
#max_parallel_workers_per_gather = 2# taken from max_worker_processes
166166
#max_parallel_workers = 8 # total maximum number of worker_processes
167167
#old_snapshot_threshold = -1# 1min-60d; -1 disables; 0 is immediate

‎src/bin/pg_resetxlog/pg_resetxlog.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -584,7 +584,7 @@ GuessControlValues(void)
584584
ControlFile.wal_log_hints= false;
585585
ControlFile.track_commit_timestamp= false;
586586
ControlFile.MaxConnections=100;
587-
ControlFile.max_worker_processes=16;
587+
ControlFile.max_worker_processes=8;
588588
ControlFile.max_prepared_xacts=0;
589589
ControlFile.max_locks_per_xact=64;
590590

@@ -800,7 +800,7 @@ RewriteControlFile(void)
800800
ControlFile.wal_log_hints= false;
801801
ControlFile.track_commit_timestamp= false;
802802
ControlFile.MaxConnections=100;
803-
ControlFile.max_worker_processes=16;
803+
ControlFile.max_worker_processes=8;
804804
ControlFile.max_prepared_xacts=0;
805805
ControlFile.max_locks_per_xact=64;
806806

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp