From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Peter Eisentraut <peter@eisentraut.org>
Cc: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@lists.postgresql.org, "Imseih (AWS), Sami" <simseih@amazon.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: allow changing autovacuum_max_workers without restarting
Date: Tue, 29 Apr 2025 17:31:01 -0400
Message-ID: <1147121.1745962261@sss.pgh.pa.us> (raw)
In-Reply-To: <aBEPe-OHYbnNezTM@nathan>
References: <1359669.1736206603@sss.pgh.pa.us>
<Z3yVFfKG_RAh8FgP@nathan>
<1386858.1736220547@sss.pgh.pa.us>
<Z31jI10tLLd6thfu@nathan>
<de722583-4ba4-4063-bc41-e20684978116@eisentraut.org>
<713236.1745846094@sss.pgh.pa.us>
<aA-TlhU2ZoBBAqc-@nathan>
<15005c8c-7676-43b7-a440-787b101cfdf5@eisentraut.org>
<1050120.1745947158@sss.pgh.pa.us>
<1052019.1745947915@sss.pgh.pa.us>
<aBEPe-OHYbnNezTM@nathan>
Nathan Bossart <nathandbossart@gmail.com> writes:
> On Tue, Apr 29, 2025 at 01:31:55PM -0400, Tom Lane wrote:
>> So now I'm inclined to leave that one alone. I'd still revert
>> 38da05346, which means the comment added by 6d0154196 needs some minor
>> adjustments. But I think we can stick with the "(max_connections /
>> 6)" formula --- it will produce 3 with trial_conns = 20, but that's
>> enough.
> Yup, as long as the lowest possible default is >= the default for
> autovacuum_max_workers (3), we're good.
Pushed. I realized that the text about SEMMNI/SEMMNS in runtime.sgml
needed some work too, since it still said that increasing them was
optional on NetBSD/OpenBSD.
regards, tom lane
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: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, nathandbossart@gmail.com, peter@eisentraut.org, andres@anarazel.de, simseih@amazon.com, pryzby@telsasoft.com
Subject: Re: allow changing autovacuum_max_workers without restarting
In-Reply-To: <1147121.1745962261@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox