Re: Question about Logical Replication

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Question about Logical Replication
Дата
Msg-id CAKFQuwb1e9MLA8kJRGEkNordWPbvDGUtTK_HD=3mCTeZkvLvLg@mail.gmail.com
обсуждение исходный текст
Ответ на Question about Logical Replication  (Efraín Déctor <efraindector@motumweb.com>)
Ответы Re: Question about Logical Replication  (Efraín Déctor <efraindector@motumweb.com>)
Список 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 по дате отправления:

Предыдущее
От: Efraín Déctor
Дата:
Сообщение: Question about Logical Replication
Следующее
От: Marco Tosato
Дата:
Сообщение: Efficient way for storing lists in PostgreSQL