[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: Analyze on slave promoted.
From:       Vik Fearing <vik.fearing () 2ndquadrant ! com>
Date:       2019-09-27 10:41:05
Message-ID: ba1c2d91-d1af-f704-7374-5f2ec771db38 () 2ndquadrant ! com
[Download RAW message or body]

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 mentioned, but other statistics are not.  In
particular, pg_stat_all_tables.n_dead_tup is not replicated and so
autovacuum has no idea when it needs to run.



[prev in list] [next in list] [prev in thread] [next in thread]