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 thi

Re: Analyze on slave promoted.

On 26/09/2019 09:54, Joao Junior wrote: > Hi, > Is this necessary to run analyze on a slave using streaming > replication  after promotion?? > Yes, you should run ANALYZE on all of your tables in all of your databases after a promotion.  The data distribution statistics are replicated, as Pavel me