Different Autovacuum Settings on Master and Replica in Streaming Replication

Franjo Stipanovic <fritzfs@gmail.com>

From: Franjo Stipanovic <fritzfs@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2025-01-17T14:37:34Z
Lists: pgsql-general
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!