Horton

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

Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

View thread View on postgr.es
From: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
To: 赵锐 <875941708@qq.com>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Amit Langote <amitlangote09@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-01-11T13:00:45Z
Lists: 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

Commits

  1. Fix relation descriptor leak.