Re: Creating many tables gets logical replication stuck

2020-08-25 Thread Laurenz Albe
On Tue, 2020-08-25 at 15:44 +0300, Achilleas Mantzios wrote: > Hello Keisuke > On 25/8/20 9:50 π.μ., Keisuke Kuroda wrote: > > Hi All, > > > > There was a similar problem in this discussion: > >Logical decoding CPU-bound w/ large number of tables > > > > https://www.postgresql.org/message-

Re: Creating many tables gets logical replication stuck

2020-08-25 Thread Achilleas Mantzios
Hello Keisuke On 25/8/20 9:50 π.μ., Keisuke Kuroda wrote: Hi All, There was a similar problem in this discussion: Logical decoding CPU-bound w/ large number of tables https://www.postgresql.org/message-id/flat/CAHoiPjzea6N0zuCi%3D%2Bf9v_j94nfsy6y8SU7-%3Dbp4%3D7qw6_i%3DRg%40mail.gmail.com

Re: Creating many tables gets logical replication stuck

2020-08-24 Thread Keisuke Kuroda
Hi All, There was a similar problem in this discussion: Logical decoding CPU-bound w/ large number of tables https://www.postgresql.org/message-id/flat/CAHoiPjzea6N0zuCi%3D%2Bf9v_j94nfsy6y8SU7-%3Dbp4%3D7qw6_i%3DRg%40mail.gmail.com > RelfilenodeMapHash from 1024 entries to 64. The above chang

Re: Creating many tables gets logical replication stuck

2020-08-21 Thread Achilleas Mantzios
Dear Laurenz thank you for your analysis and report. On 21/8/20 4:00 μ.μ., Laurenz Albe wrote: Reproducer on 12.4: This is identical problem with this report here : https://www.postgresql.org/message-id/6fa054d8-ad14-42a2-8926-5d79c97ecd65%40matrix.gatewaynet.com Yours, Laurenz Albe -- Ach

Creating many tables gets logical replication stuck

2020-08-21 Thread Laurenz Albe
Reproducer on 12.4: On the primary: CREATE TABLE repli (id bigint PRIMARY KEY, val text NOT NULL); CREATE PUBLICATION repli_pub FOR TABLE repli; On the standby: CREATE TABLE repli (id bigint PRIMARY KEY, val text NOT NULL); CREATE SUBSCRIPTION repli_sub CONNECTION '...' PUBLICATION repli_pub;