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!
