Re: Control flow in logical replication walsender

On Tue, May 7, 2024 at 12:00 AM Christophe Pettus <xof(at)thebuild(dot)com> wrote:

> Thank you for the reply!
>
> > On May 1, 2024, at 02:18, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)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