From: Laurenz Albe <laurenz.albe@cybertec.at>
To: SOzcn <selahattinozcnma@gmail.com>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Vacuum
Date: Tue, 02 Jan 2024 20:34:52 +0100
Message-ID: <6aa1d44a363d3af90fde41ae03aa27b08b86bdd2.camel@cybertec.at> (raw)
In-Reply-To: <CAJyV5AZ98-2iO=JjJnbqchq4u53HkH7qg2B24nMvGiJbR2JBuw@mail.gmail.com>
References: <CAJk5AtaK_k+qpAr4xNzymYKvTrcVukW7RaFfrFmd-EwDVqhdQg@mail.gmail.com>
<CAJyV5AZ98-2iO=JjJnbqchq4u53HkH7qg2B24nMvGiJbR2JBuw@mail.gmail.com>
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.
Yours,
Laurenz Albe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, selahattinozcnma@gmail.com, rajeshkumar.dba09@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Vacuum
In-Reply-To: <6aa1d44a363d3af90fde41ae03aa27b08b86bdd2.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox