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
ew" column.
Foreign keys remain intact with this solution and you don't have double
wal logging like for an UPDATE.
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
