| From: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
|---|---|
| To: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Subject: | Re: logical replication walsender loop preventing a clean shutdown |
| Date: | 2024-09-16 22:56:45 |
| Message-ID: | CAD21AoA3hepMcJYvyZoo1Ec=sSqvudS4jUQVqqEbyj5ui8jnEQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, Sep 16, 2024 at 11:28 AM Greg Sabino Mullane <htamfids(at)gmail(dot)com> wrote:
>
> When doing logical replication, a large transaction can prevent the postgres process from shutting down until the WAL has all 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,
--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2024-09-17 05:28:53 | BUG #18621: postgres_fdw cannot work with tables that use schemaless functions in triggers |
| Previous Message | Tom Lane | 2024-09-16 21:11:09 | Re: BUG #18618: pg_upgrade from 14 to 15+ fails for unlogged table with identity column |