public inbox for [email protected]  

help / color / mirror / Atom feed

From: Greg Stark <[email protected]>
To: Jonathan S. Katz <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: Amit Kapila <[email protected]>
Cc: Andres Freund <[email protected]>
Cc: Justin Pryzby <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Cc: [email protected]
Subject: Re: Should we remove vacuum_defer_cleanup_age?
Date: Fri, 14 Apr 2023 11:25:34 -0400
Message-ID: <CAM-w4HOiHaNgrBZGWGhOeset21jdFN5grdqZFLXXos6uCNnSHQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<ZDWLvS1GghESoX/[email protected]>
	<[email protected]>
	<CAA4eK1+s7hyed2ZSwTC42N6VqCV73CGtzBRfcf1qgjCSJbO3Gw@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<CA+TgmoaZXaY_xJakDxZMeUUG+CuuuDmL+Yg8-LjPL5kiT-2Zjg@mail.gmail.com>
	<[email protected]>

On Fri, 14 Apr 2023 at 09:47, Jonathan S. Katz <[email protected]> wrote:
>
> Let me restate [1] in a different way.
>
> Using a large enough dataset, I did qualitatively look at overall usage
> of both "vacuum_defer_cleanup_age" and compared to
> "hot_standby_feedback", given you can use both to accomplish similar
> outcomes.

I assume people would use hot_standby_feedback if they have streaming
replication. The main use cases for vacuum_defer_cleanup_age would be
if you're replaying WAL files. That may sound archaic but there are
plenty of circumstances where your standby may not have network access
to your primary at all or not want to be replaying continuously.

I wonder whether your dataset is self-selecting sites that have
streaming replication. That does seem like the more common usage
pattern.

Systems using wal files are more likely to be things like data
warehouses, offline analytics systems, etc. They may not even be well
known in the same organization that runs the online operations -- in
my experience they're often run by marketing or sales organizations or
in some cases infosec teams and consume data from lots of sources. The
main reason to use wal archive replay is often to provide the
isolation so that the operations team don't need to worry about the
impact on production and that makes it easy to forget these even
exist.

-- 
greg

view thread (5+ 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], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Should we remove vacuum_defer_cleanup_age?
  In-Reply-To: <CAM-w4HOiHaNgrBZGWGhOeset21jdFN5grdqZFLXXos6uCNnSHQ@mail.gmail.com>

* 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