On Tue, 2024-01-02 at 18:33 +0300, SOzcn wrote: > Rajesh Kumar <rajeshkumar.dba09@gmail.com>, 2 Oca 2024 Sal, 18:07 tarihinde şunu yazdı: > > Postgres 15 > > > > I am creating a new replica, and after the data is caught up and replication lag is 0, > > I am doing a switchover and making a new replica as master. > > > > Now, in this case, do I have so vacuum analyze in master? > > Hello, I've tried the same thing, you need to analyze your databases in any case. > Don't need a Full vacuum.
I don't think that is true. Both table statistics and the effects of VACUUM are replicated.
What is not replicated are the statistics in "pg_stat_all_tables", so autovacuum loses its brain during a switchover.