Re: Different Autovacuum Settings on Master and Replica in Streaming Replication

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
Дата
Msg-id CAECtzeWsUE5EV_w8yRre28hZBUXPWE-fkFrqf7__B29jWAjP3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Different Autovacuum Settings on Master and Replica in Streaming Replication  (Franjo Stipanovic <fritzfs@gmail.com>)
Ответы Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
Список pgsql-general
Дерево обсуждения
Hi,

Le ven. 17 janv. 2025 à 15:38, Franjo Stipanovic <fritzfs@gmail.com> a écrit :

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. 


They could but it doesn't matter. VACUUM and ANALYZE aren't executed on replicas because they are write operations, and you can't write on replicas.
 

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? 

Changes on the postgresq.conf file aren't replicated, but ALTER TABLE ... (SET autovacuum...) are.

I was expecting that this is not possible in streaming replication, only in logical replication.


You're right, it's not possible.


--
Guillaume.

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