public inbox for [email protected]
help / color / mirror / Atom feedFrom: Franjo Stipanovic <[email protected]>
To: [email protected]
Subject: Different Autovacuum Settings on Master and Replica in Streaming Replication
Date: Fri, 17 Jan 2025 15:37:34 +0100
Message-ID: <CAJyBP14Vtwmds7vM8nO2GWaXHq3_-Dw1-_+iY0onXVJKWETUDg@mail.gmail.com> (raw)
Question regarding autovacuum settings in a PostgreSQL streaming
replication setup. Specifically, I am curious about whether it is possible
(and advisable) to have different values for the following settings on the
master and replica databases:
- autovacuum_vacuum_scale_factor
- autovacuum_analyze_scale_factor
Can the above settings be configured differently on the master and replica
databases in a streaming replication setup? I just tested this on AWS RDS
Postgres.
How would those different settings interact with replication, for example,
if I apply change on master, would it be replicated to replica and override
my replica setting?
I was expecting that this is not possible in streaming replication, only in
logical replication.
Thank you!
view thread (2+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
In-Reply-To: <CAJyBP14Vtwmds7vM8nO2GWaXHq3_-Dw1-_+iY0onXVJKWETUDg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox