| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | SOzcn <selahattinozcnma(at)gmail(dot)com>, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Vacuum |
| Date: | 2024-01-02 19:34:52 |
| Message-ID: | 6aa1d44a363d3af90fde41ae03aa27b08b86bdd2.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, 2024-01-02 at 18:33 +0300, SOzcn wrote:
> Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar | 2024-01-02 19:52:15 | Re: Vacuum |
| Previous Message | Tom Lane | 2024-01-02 16:27:26 | Re: PostgreSQL local connection is taking 4 seconds |