Horton

Re: repeated decoding of prepared transactions

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Markus Wanner <markus.wanner@enterprisedb.com>
Cc: Ajin Cherian <itsajin@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, robertmhaas@gmail.com, simon.riggs@enterprisedb.com, petr.jelinek@enterprisedb.com
Date: 2021-02-22T09:25:25Z
Lists: pgsql-hackers 
Hi,

On 2021-02-22 09:25:52 +0100, Markus Wanner wrote:
> What issues do you see with the approach I proposed?

Very significant increase in complexity for initializing a logical
replica, because there's no easy way to just use the initial slot.

- Andres

Commits

  1. Add option to enable two_phase commits via pg_create_logical_replication_slot.

  2. Avoid repeated decoding of prepared transactions after a restart.

  3. Allow decoding at prepare time in ReorderBuffer.