public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Franjo Stipanovic <[email protected]>
Cc: [email protected]
Subject: Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
Date: Fri, 17 Jan 2025 10:34:23 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAJyBP14Vtwmds7vM8nO2GWaXHq3_-Dw1-_+iY0onXVJKWETUDg@mail.gmail.com>
References: <CAJyBP14Vtwmds7vM8nO2GWaXHq3_-Dw1-_+iY0onXVJKWETUDg@mail.gmail.com>

Franjo Stipanovic <[email protected]> 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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox