pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedVacuum behaviour for replicated nodes with pglogical (postgres 10)
2+ messages / 2 participants
[nested] [flat]
* Vacuum behaviour for replicated nodes with pglogical (postgres 10)
@ 2022-03-24 08:39 Dirk Krautschick <Dirk.Krautschick@trivadis.com>
0 siblings, 1 reply; 2+ messages in thread
From: Dirk Krautschick @ 2022-03-24 08:39 UTC (permalink / raw)
To: pgsql-admin
Hi
should I expect the same vacuum behaviour on both nodes replicated with pglogical
if both nodes have the very same autovacuum settings?
The insert, update, delete do have the same affect on the threshold on standby side, right?
Or are there any pitfalls using pglogical in this contect?
Thanks and cheers
Dirk
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Vacuum behaviour for replicated nodes with pglogical (postgres 10)
@ 2022-03-30 06:59 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
parent: Dirk Krautschick <Dirk.Krautschick@trivadis.com>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2022-03-30 06:59 UTC (permalink / raw)
To: Dirk Krautschick <Dirk.Krautschick@trivadis.com>; pgsql-admin
On 24.03.22 09:39, Dirk Krautschick wrote:
> should I expect the same vacuum behaviour on both nodes replicated with
> pglogical
>
> if both nodes have the very same autovacuum settings?
>
> The insert, update, delete do have the same affect on the threshold on
> standby side, right?
Yes, it should roughly be the same.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-03-30 06:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-03-24 08:39 Vacuum behaviour for replicated nodes with pglogical (postgres 10) Dirk Krautschick <Dirk.Krautschick@trivadis.com>
2022-03-30 06:59 ` Peter Eisentraut <peter.eisentraut@enterprisedb.com>
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