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
Hi
čt 26. 9. 2019 v 9:55 odesílatel Joao Junior 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
Hi,
Is this necessary to run analyze on a slave using streaming replication
after promotion??
