From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: "Multiple table synchronizations are processed serially" still happens |
Date: | 2021-04-28 09:37:20 |
Message-ID: | CAECtzeVqNdgM52hO0HA2oB3WNu18Vq0d+OfWiriWKeEz5_qj_w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Le mer. 28 avr. 2021 à 11:12, Guillaume Lelarge <guillaume(at)lelarge(dot)info> a
écrit :
> Hi,
>
> One of my customers has an issue with logical replication. As $SUBJECT
> says, multiple table synchronization happens serially. To be honest, it
> doesn't do this every time. It happens when the tables are big enough.
>
> This issue was already described on this thread (from 2017):
> https://www.postgresql.org/message-id/flat/CAD21AoC2KJdavS7MFffmSsRc1dn3Vg_0xmuc=UpBrZ-_MUxh-Q(at)mail(dot)gmail(dot)com
>
> This thread was closed by a commit (
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6c2003f8a1bbc7c192a2e83ec51581c018aa162f)
> which apparently fixed the issue for the OP.
>
> Attached is a small test case where it still happens for me on 12.6,
> 11.11, and 10.16. I can't make it happen on 13.2. I don't know why. It may
> imply bigger tables for 13.2, but why? I simply don't know.
>
>
Actually, it also happens on 13.2.
--
Guillaume.
From | Date | Subject | |
---|---|---|---|
Next Message | Bharath Rupireddy | 2021-04-28 09:38:36 | Re: Result Cache node shows per-worker info even for workers not launched |
Previous Message | Guillaume Lelarge | 2021-04-28 09:12:51 | "Multiple table synchronizations are processed serially" still happens |