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
|
| Список | pgsql-novice |
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 по дате отправления: