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

Commitff7bce1

Browse files
committed
Add max_sync_workers_per_subscription to postgresql.conf.sample.
This commit also does- add REPLICATION_SUBSCRIBERS into config_group- mark max_logical_replication_workers and max_sync_workers_per_subscription as REPLICATION_SUBSCRIBERS parameters- move those parameters into "Subscribers" section in postgresql.conf.sampleAuthor: Masahiko Sawada, Petr Jelinek and meReported-by: Masahiko SawadaDiscussion:http://postgr.es/m/CAD21AoAonSCoa=v=87ZO3vhfUZA1k_E2XRNHTt=xioWGUa+0ug@mail.gmail.com
1 parent1c1a472 commitff7bce1

File tree

3 files changed

+12
-3
lines changed

3 files changed

+12
-3
lines changed

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

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -610,6 +610,8 @@ const char *const config_group_names[] =
610610
gettext_noop("Replication / Master Server"),
611611
/* REPLICATION_STANDBY */
612612
gettext_noop("Replication / Standby Servers"),
613+
/* REPLICATION_SUBSCRIBERS */
614+
gettext_noop("Replication / Subscribers"),
613615
/* QUERY_TUNING */
614616
gettext_noop("Query Tuning"),
615617
/* QUERY_TUNING_METHOD */
@@ -2511,7 +2513,7 @@ static struct config_int ConfigureNamesInt[] =
25112513
{
25122514
{"max_logical_replication_workers",
25132515
PGC_POSTMASTER,
2514-
RESOURCES_ASYNCHRONOUS,
2516+
REPLICATION_SUBSCRIBERS,
25152517
gettext_noop("Maximum number of logical replication worker processes."),
25162518
NULL,
25172519
},
@@ -2523,7 +2525,7 @@ static struct config_int ConfigureNamesInt[] =
25232525
{
25242526
{"max_sync_workers_per_subscription",
25252527
PGC_SIGHUP,
2526-
RESOURCES_ASYNCHRONOUS,
2528+
REPLICATION_SUBSCRIBERS,
25272529
gettext_noop("Maximum number of table synchronization workers per subscription."),
25282530
NULL,
25292531
},

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

Lines changed: 7 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -164,7 +164,6 @@
164164
#max_parallel_workers_per_gather = 2# taken from max_parallel_workers
165165
#max_parallel_workers = 8 # maximum number of max_worker_processes that
166166
# can be used in parallel queries
167-
#max_logical_replication_workers = 4# taken from max_worker_processes
168167
#old_snapshot_threshold = -1# 1min-60d; -1 disables; 0 is immediate
169168
# (change requires restart)
170169
#backend_flush_after = 0# measured in pages, 0 disables
@@ -273,6 +272,13 @@
273272
#wal_retrieve_retry_interval = 5s# time to wait before retrying to
274273
# retrieve WAL after a failed attempt
275274

275+
# - Subscribers -
276+
277+
# These settings are ignored on a publisher.
278+
279+
#max_logical_replication_workers = 4# taken from max_worker_processes
280+
#max_sync_workers_per_subscription = 2# taken from max_logical_replication_workers
281+
276282

277283
#------------------------------------------------------------------------------
278284
# QUERY TUNING

‎src/include/utils/guc_tables.h

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -72,6 +72,7 @@ enum config_group
7272
REPLICATION_SENDING,
7373
REPLICATION_MASTER,
7474
REPLICATION_STANDBY,
75+
REPLICATION_SUBSCRIBERS,
7576
QUERY_TUNING,
7677
QUERY_TUNING_METHOD,
7778
QUERY_TUNING_COST,

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp