Re: Question about Logical Replication - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Question about Logical Replication
Date
Msg-id CAKFQuwb1e9MLA8kJRGEkNordWPbvDGUtTK_HD=3mCTeZkvLvLg@mail.gmail.com
Whole thread Raw
In response to Question about Logical Replication  (Efraín Déctor <efraindector@motumweb.com>)
Responses Re: Question about Logical Replication
List pgsql-novice
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.

pgsql-novice by date:

Previous
From: Efraín Déctor
Date:
Subject: Question about Logical Replication
Next
From: Marco Tosato
Date:
Subject: Efficient way for storing lists in PostgreSQL