Re: Analyze on slave promoted.

Pavel Stehule <[email protected]> Thu, 26 Sep 2019 10:31:10 +0200
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CAFj8pRAMya_OD+A-E+07JBZX1kS9=FQmyy4r5MDPm-daXsb_Tg@mail.gmail.com>
Hi

čt 26. 9. 2019 v 9:55 odesílatel Joao Junior <[email protected]> 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