public inbox for [email protected]
help / color / mirror / Atom feedFrom: Nathan Bossart <[email protected]>
To: Sami Imseih <[email protected]>
Cc: Frédéric Yhuel <[email protected]>
Cc: Robert Treat <[email protected]>
Cc: wenhui qiu <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: Imseih (AWS), Sami <[email protected]>
Cc: David Rowley <[email protected]>
Cc: Joe Conway <[email protected]>
Cc: Michael Banck <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: Melanie Plageman <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: New GUC autovacuum_max_threshold ?
Date: Tue, 14 Jan 2025 11:45:42 -0600
Message-ID: <Z4aixpJfyzkRfuJc@nathan> (raw)
In-Reply-To: <CAA5RZ0sgq90BvbQry4bRcFNpz6S+A08iTguk=N-dcBW51Z3CeA@mail.gmail.com>
References: <CAGjGUAKSvvQA583hk-62HyBRhPvowNbhv5+QiRt+znWMA+5OLg@mail.gmail.com>
<Z32xZZwOi5pXZjYU@nathan>
<[email protected]>
<Z37ZlVqUzSapV3ZD@nathan>
<CABV9wwNxNTEgq0n5DJVDD+mgMbqBJv1-W6R3Dfry4a9C9=z=Uw@mail.gmail.com>
<Z4AQJYdOsvVHNIbt@nathan>
<Z4V1sDjqJ1CnqScY@nathan>
<CAA5RZ0tAqjtJz+2=S1LvDUJfrpGa73nmLccwvr_R1r8CC4HmaA@mail.gmail.com>
<Z4XHQR6_AVKiyFjG@nathan>
<CAA5RZ0sgq90BvbQry4bRcFNpz6S+A08iTguk=N-dcBW51Z3CeA@mail.gmail.com>
On Tue, Jan 14, 2025 at 11:08:36AM -0600, Sami Imseih wrote:
> After staring at the documentation for a while, I am now
> wondering whether we are adequately describing the
> rationale for this GUC. The GUC documentation mentions that this is a
> 'cap on the value calculated with autovacuum_vacuum_threshold
> and autovacuum_vacuum_scale_factor,' which is acceptable;
> however, I think further elaboration is necessary in
> routine-vacuuming.html#AUTOVACUUM. This is because
> scale_factor and threshold are already well-known
> and widely understood parameters, and introducing
> a third one to the mix deserves a bit more of an
> explanation. What do you think?
I think it would be odd to explain the intent for one autovacuum parameter
while leaving the others unexplained. IMHO it would be better to address
this for all such parameters in a follow-up patch.
--
nathan
view thread (13+ messages) latest in thread
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], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: New GUC autovacuum_max_threshold ?
In-Reply-To: <Z4aixpJfyzkRfuJc@nathan>
* 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