maximum number of subscriptions from the subscriber side

Поиск
Список
Период
Сортировка
От Wim Bertels
Тема maximum number of subscriptions from the subscriber side
Дата
Msg-id 5294e137525806ff1ae7e2a0bb23a7db2594e1b7.camel@ucll.be
обсуждение исходный текст
Список pgsql-admin
Hello,

Using the built in logical replication.

I am trying out a small stress test, 
with a 100 subscriptions to 1 publication between 2 servers
(1 database per subscription on the subscriber side)

All the 100 slots are made, visible on the publication and subscription
server, but only 10 subscriptions were active at first?

Based on:
https://www.postgresql.org/docs/current/runtime-config-replication.html
point 19.6.4
i have adapted these settings in the subscription side:

max_sync_workers_per_subscription      | 2 
max_logical_replication_workers        | 128
max_worker_processes                   | 136

But i noticed i also needed to change (on the subscriber server):
max_replication_slots (default 10) to a least 100
for all the 100 subscriptions to actually work.
(otherwise there were only 10 active subscription processes)

This wasn't clear for me from the documentation,
but probably i missed something?

PS: while testing this, the main for the publishing server seems cpu
$w
 19:03:28 up 15 days,  3:47,  3 users,  load average: 46,77, 63,02,
39,37
(in case of a publishing server with very little writes, 4 cores! and
8GB ram; ram seemed fine though)
PPS: this is a special use, this not a regular one.

-- 
mvg,
Wim





В списке pgsql-admin по дате отправления:

Предыдущее
От: postgann2020 s
Дата:
Сообщение: Suggestion to Monitoring Tool
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: suggestion the process to sync the data from PROD DB to Staging environment