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

2021-01-12 Thread Amit Kapila
On Mon, Jan 11, 2021 at 6:31 PM Ashutosh Bapat wrote: > > On Mon, Jan 4, 2021 at 7:07 PM 赵锐 <875941...@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=Y85vR

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

2021-01-11 Thread Ashutosh Bapat
On Mon, Jan 4, 2021 at 7:07 PM 赵锐 <875941...@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=_ejmoo...@mail.gmail.com > And I believe patch

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

2021-01-04 Thread ????
Logical replication on partition table is very slow and CPU is 99%. To reproduce this problem, pg1 for publish pgbench -i -s 1000 create table pgbench_accounts_copy(aid integer, bid integer, abalance integer, filler character(84)) partition by range (aid); create table pgbench_accounts_