Re: Question about Logical Replication

Thank you David.

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

Thanks again!

El 11/12/2017 a las 01:42 p. m., David G. Johnston escribió:
> On Mon, Dec 11, 2017 at 12:26 PM, Efraín Déctor
> <efraindector(at)motumweb(dot)com <mailto:efraindector(at)motumweb(dot)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.
>