| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
| Cc: | 赵锐 <875941708(at)qq(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [Bug Fix] Logical replication on partition table is very slow and CPU is 99% |
| Date: | 2021-01-12 08:13:32 |
| Message-ID: | CAA4eK1K6Jz+wzONJWmHWs4V=ykRkAO3zx-9hs8DyE=ZzQfJCQA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Jan 11, 2021 at 6:31 PM Ashutosh Bapat
<ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> wrote:
>
> On Mon, Jan 4, 2021 at 7:07 PM 赵锐 <875941708(at)qq(dot)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(at)mail(dot)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luc Vlaming | 2021-01-12 08:30:26 | Re: Parallel Inserts in CREATE TABLE AS |
| Previous Message | Amit Kapila | 2021-01-12 08:11:37 | Re: adding partitioned tables to publications |