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
