Re: [Bug Fix] Logical replication on partition table is very slow and CPU is 99%

Поиск
Список
Период
Сортировка
От Ashutosh Bapat
Тема Re: [Bug Fix] Logical replication on partition table is very slow and CPU is 99%
Дата
Msg-id CAExHW5tDfbWQ1MttgAALk=j46BiL6V+m5WGD0+v0K9Hy=0PBwA@mail.gmail.com
обсуждение исходный текст
Ответ на [Bug Fix] Logical replication on partition table is very slow and CPU is 99%  ("赵锐" <875941708@qq.com>)
Ответы Re: [Bug Fix] Logical replication on partition table is very slow and CPU is 99%  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Mon, Jan 4, 2021 at 7:07 PM 赵锐 <875941708@qq.com> wrote:

>
>
> This patch adds the missed decrement to resolve the problem.
>

>
> Previous discussion is here:
https://www.postgresql.org/message-id/flat/CA+HiwqH=Y85vRK3mOdjEkqFK+E=ST=eQiHdpj43L=_eJMOOznQ@mail.gmail.com
> And I believe patch #83fd453 introduce this problem.
>


Thanks for the report and fix. The fix looks straight forward and
correct to me. Please add the patch to the next CF so that it's not
forgotten. But since this is a bug fix it need not wait for CF.

Also please report the results of your experiment with the patch
applied so as to know this bug's contribution to the slow down.

--
Best Wishes,
Ashutosh Bapat



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Mark Zhao"
Дата:
Сообщение: Re: adding partitioned tables to publications
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION