Re: Updating large tables without dead tuples

2018-03-02 Thread Vik Fearing
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

Re: Analyze on slave promoted.

2019-09-27 Thread Vik Fearing
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