Re: Question about Logical Replication

Thank you David.

So the defaults are fine for me since I will only have 1 subscriber.

Thanks again!

On Mon, Dec 11, 2017 at 12:26 PM, Efraín Déctor <efraindector@motumweb.com> wrote:

Hello.

Do I need to configure the settings (max_replication_slots , max_wal_senders, etc) according to the number of tables to be replicated?

​In short, no.  The determination of values for these settings is based upon other aspects of the overall multi-server system.​

Physical replication is cluster-based, not table based.  The slots/senders are roughly the number of servers involved in the setup.

Logical replication is publication based.

"A publication is a set of changes generated from a table or a group of tables, and might also be described as a change set or replication set. Each publication exists in only one database."

The slots/senders are consumed as servers subscribe to publications.

David J.