Re: Allowing TRUNCATE of FK target when session_replication_role=replica

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: Allowing TRUNCATE of FK target when session_replication_role=replica
Дата
Msg-id bbcb9163-0b3e-4d44-a990-40881d96adcb@app.fastmail.com
обсуждение исходный текст
Ответ на Re: Allowing TRUNCATE of FK target when session_replication_role=replica  (Hannu Krosing <hannuk@google.com>)
Список pgsql-hackers
Дерево обсуждения


On Tue, Oct 31, 2023, at 3:21 PM, Hannu Krosing wrote:
One thing though re:
> The former is true but the latter is not. Logical replication requires
> wal_level = logical. That's also true for skipping FSM.

wal_level=logical is only needed *at provider* side, at least when
running pglogical.

It is not a requirement for the subscriber. However, it increases the
complexity for a real scenario (in which you set up backup and sometimes
additional physical replicas) because key GUCs require a restart.


--
Euler Taveira
EDB   https://www.enterprisedb.com/

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: CRC32C Parallel Computation Optimization on ARM
Следующее
От: Matthias van de Meent
Дата:
Сообщение: btree: implement dynamic prefix truncation (was: Improving btree performance through specializing by key shape, take 2)