Re: Vacuum
| От | Rajesh Kumar |
|---|---|
| Тема | Re: Vacuum |
| Дата | |
| Msg-id | CAJk5AtbUHzJFX-xDpeDq=gWXcgv1QteLjyo=JBLbbbQkHo5msA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Vacuum (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: Vacuum
|
| Список | pgsql-admin |
Vacuum operation happens only in primary. How is that replicated?
On Wed, 3 Jan 2024, 01:04 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
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
В списке pgsql-admin по дате отправления: