Re: Allowing TRUNCATE of FK target when session_replication_role=replica

From: "Euler Taveira" <euler(at)eulerto(dot)com>
To: "Hannu Krosing" <hannuk(at)google(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Allowing TRUNCATE of FK target when session_replication_role=replica
Date: 2023-10-31 21:10:15
Message-ID: bbcb9163-0b3e-4d44-a990-40881d96adcb@app.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthias van de Meent 2023-10-31 21:12:26 btree: implement dynamic prefix truncation (was: Improving btree performance through specializing by key shape, take 2)
Previous Message Nathan Bossart 2023-10-31 20:48:21 Re: CRC32C Parallel Computation Optimization on ARM