| From: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
|---|---|
| To: | 赵锐 <875941708(at)qq(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> |
| Cc: | 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-11 13:00:45 |
| Message-ID: | CAExHW5tDfbWQ1MttgAALk=j46BiL6V+m5WGD0+v0K9Hy=0PBwA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bharath Rupireddy | 2021-01-11 13:21:15 | Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION |
| Previous Message | Mark Zhao | 2021-01-11 12:03:34 | Re: adding partitioned tables to publications |