Re: Unresolved repliaction hang and stop problem. - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Unresolved repliaction hang and stop problem.
Date
Msg-id CAA4eK1KLtCHGn_8e07HsyjggkjoR68SQkpJr-a9ZtA3Q2oC_0A@mail.gmail.com
Whole thread Raw
In response to Unresolved repliaction hang and stop problem.  (Krzysztof Kois <krzysztof.kois@unitygroup.com>)
Responses Re: Unresolved repliaction hang and stop problem.  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
On Tue, Apr 13, 2021 at 1:18 PM Krzysztof Kois
<krzysztof.kois@unitygroup.com> wrote:
>
> Hello,
> After upgrading the cluster from 10.x to 13.1 we've started getting a problem describe pgsql-general:
> https://www.postgresql.org/message-id/8bf8785c-f47d-245c-b6af-80dc1eed40db%40unitygroup.com
> We've noticed similar issue being described on this list in
>
https://www.postgresql-archive.org/Logical-replication-CPU-bound-with-TRUNCATE-DROP-CREATE-many-tables-tt6155123.html
> with a fix being rolled out in 13.2.
>

The fix for the problem discussed in the above threads is committed
only in PG-14, see [1]. I don't know what makes you think it is fixed
in 13.2. Also, it is not easy to back-patch that because this fix
depends on some of the infrastructure introduced in PG-14.

[1] - https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d7eb52d7181d83cf2363570f7a205b8eb1008dbc

-- 
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Truncate in synchronous logical replication failed
Next
From: Himanshu Upadhyaya
Date:
Subject: Re: [PATCH] PREPARE TRANSACTION unexpected behavior with TEMP TABLE