Home > mailing lists

Re: Analyze on slave promoted. - Mailing list pgsql-performance

From	Pavel Stehule
Subject	Re: Analyze on slave promoted.
Date	September 26, 2019 11:31:10
Msg-id	CAFj8pRAMya_OD+A-E+07JBZX1kS9=FQmyy4r5MDPm-daXsb_Tg@mail.gmail.com Whole thread Raw
In response to	Analyze on slave promoted. (Joao Junior <jcoj2006@gmail.com>)
List	pgsql-performance

čt 26. 9. 2019 v 9:55 odesílatel Joao Junior <jcoj2006@gmail.com> napsal:

Hi,
Is this necessary to run analyze on a slave using streaming replication after promotion??

No - column statistics are come from master - and are persistent - promote change nothing.

Pavel

From: Joao Junior
Date: 26 September 2019, 10:54:40
Subject: Analyze on slave promoted.

From: Edilmar Alves
Date: 26 September 2019, 23:37:02
Subject: Slow pg_publication_tables with many schemas and tables