Re: Unresolved repliaction hang and stop problem.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Unresolved repliaction hang and stop problem.
Дата
Msg-id CAA4eK1KLtCHGn_8e07HsyjggkjoR68SQkpJr-a9ZtA3Q2oC_0A@mail.gmail.com
обсуждение исходный текст
Ответ на Unresolved repliaction hang and stop problem.  (Krzysztof Kois <krzysztof.kois@unitygroup.com>)
Ответы Re: Unresolved repliaction hang and stop problem.
Список 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 по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Truncate in synchronous logical replication failed
Следующее
От: Himanshu Upadhyaya
Дата:
Сообщение: Re: [PATCH] PREPARE TRANSACTION unexpected behavior with TEMP TABLE