Horton

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

Amit Kapila <amit.kapila16@gmail.com>

View thread View on postgr.es
From: Amit Kapila <amit.kapila16@gmail.com>
To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Cc: 赵锐 <875941708@qq.com>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Amit Langote <amitlangote09@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-01-12T08:13:32Z
Lists: pgsql-hackers 
On Mon, Jan 11, 2021 at 6:31 PM Ashutosh Bapat
<ashutosh.bapat.oss@gmail.com> wrote:
>
> 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.
>

I have pushed the fix for this. This was also being discussed in the
nearby thread [1].

[1] - https://www.postgresql.org/message-id/tencent_41FEA657C206F19AB4F406BE9252A0F69C06%40qq.com

-- 
With Regards,
Amit Kapila.

Commits

  1. Fix relation descriptor leak.