Re: Slow pg_publication_tables with many schemas and tables

Hi, Em 26/09/2019 19:11, Tom Lane escreveu: Edilmar Alves writes: I use PG 11.5 into CentOS6 server, with 50 schemas, exactly equals in tables structure, and more than 400 tables/schema. Then, there is more than 2 tables. Possibly you should rethink that design, but ... My design is

Slow pg_publication_tables with many schemas and tables

Hi, I use PG 11.5 into CentOS6 server, with 50 schemas, exactly equals in tables structure, and more than 400 tables/schema. Then, there is more than 2 tables. I found the discussion in pgsql-general thread: https://www.postgresql.org/message-id/flat/11566.1558463253%40sss.pgh.pa.us#ec14