Different Autovacuum Settings on Master and Replica in Streaming Replication

Поиск
Список
Период
Сортировка
От Franjo Stipanovic
Тема Different Autovacuum Settings on Master and Replica in Streaming Replication
Дата
Msg-id CAJyBP14Vtwmds7vM8nO2GWaXHq3_-Dw1-_+iY0onXVJKWETUDg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
Список 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!

В списке pgsql-general по дате отправления: