Postgres Pro
Downloads
Home   >   mailing lists

Re: logical replication walsender loop preventing a clean shutdown - Mailing list pgsql-bugs

From Masahiko Sawada
Subject Re: logical replication walsender loop preventing a clean shutdown
Date
Msg-id CAD21AoA3hepMcJYvyZoo1Ec=sSqvudS4jUQVqqEbyj5ui8jnEQ@mail.gmail.com
Whole thread Raw
In response to logical replication walsender loop preventing a clean shutdown  (Greg Sabino Mullane <htamfids@gmail.com>)
Responses Re: logical replication walsender loop preventing a clean shutdown
List pgsql-bugs
Tree view 
On Mon, Sep 16, 2024 at 11:28 AM Greg Sabino Mullane <htamfids@gmail.com> wrote:
>
> When doing logical replication, a large transaction can prevent the postgres process from shutting down until the WAL
hasall been processed and the client reports back. 

Yeah, IIUC logical wanseder waits for all sent data to be flushed on
the subscriber. There is a related proposal and discussion[1] but
nothing gets committed yet.

Regards,

[1]
https://www.postgresql.org/message-id/TYAPR01MB586668E50FC2447AD7F92491F5E89@TYAPR01MB5866.jpnprd01.prod.outlook.com

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18618: pg_upgrade from 14 to 15+ fails for unlogged table with identity column
Next
From: PG Bug reporting form
Date:
Subject: BUG #18621: postgres_fdw cannot work with tables that use schemaless functions in triggers