Franjo Stipanovic <fritzfs@xxxxxxxxx> writes: > 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 A streaming replica will not run vacuum on its own, as it just absorbs the physical changes made by vacuum on the master. Hence, it matters not at all how you have those values set on the replica. If the replica is promoted to master, then it will start to use whatever settings it has (and no, postgresql.conf is not copied by the replication infrastructure). regards, tom lane
