Re: Control flow in logical replication walsender - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: Control flow in logical replication walsender
Date
Msg-id CAExHW5tQJk0sVAsZpFw11qvbHhO7GgQ2oz0Zrx-MM0SfuPooVg@mail.gmail.com
Whole thread Raw
In response to Re: Control flow in logical replication walsender  (Christophe Pettus <xof@thebuild.com>)
Responses Re: Control flow in logical replication walsender
List pgsql-hackers


On Tue, May 7, 2024 at 12:00 AM Christophe Pettus <xof@thebuild.com> wrote:
Thank you for the reply!

> On May 1, 2024, at 02:18, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> wrote:
> Is there a large transaction which is failing to be replicated repeatedly - timeouts, crashes on upstream or downstream?

AFAIK, no, although I am doing this somewhat by remote control (I don't have direct access to the failing system).  This did bring up one other question, though:

Are subtransactions written to their own individual reorder buffers (and thus potentially spill files), or are they appended to the topmost transaction's reorder buffer?

IIRC, they have their own RB, but once they commit, they are transferred to topmost transaction's RB. So they can spill files.

--
Best Wishes,
Ashutosh Bapat

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 2024-05-09 release announcement draft
Next
From: "Jingxian Li"
Date:
Subject: Re: [PATCH] Fix bug when calling strncmp in check_authmethod_valid