Re: Vacuum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2024-01-02 at 18:33 +0300, SOzcn wrote:
> Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx>, 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.

Yours,
Laurenz Albe






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux