pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: Nathan Bossart <nathandbossart@gmail.com>
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 13:19:18 -0400
Message-ID: <1050120.1745947158@sss.pgh.pa.us> (raw)
In-Reply-To: <15005c8c-7676-43b7-a440-787b101cfdf5@eisentraut.org>
References: <Z3xV_b3wp-XQR3Rm@nathan>
	<7B8590B5-3A23-4CF6-B21D-4AA8C0177C2C@anarazel.de>
	<1353350.1736202977@sss.pgh.pa.us>
	<Z3xlNmC3qtwf1lz1@nathan>
	<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>

Peter Eisentraut <peter@eisentraut.org> writes:
> On 28.04.25 16:41, Nathan Bossart wrote:
>> However, weren't we considering reverting some of this stuff [0]?  I see
>> that sawshark is now choosing max_connections = 40 and
>> autovacuum_worker_slots = 6, and since there are no other apparent related
>> buildfarm failures, I'm assuming that nobody else is testing the 60
>> semaphores case anymore.
>> 
>> [0] https://postgr.es/m/618497.1742347456%40sss.pgh.pa.us

> (I don't have any thoughts on this.)

Andres seemed lukewarm about reverting 38da05346 or 6d0154196, so
I left it be for the moment.  But I still feel the argument is good
that "these will do little except confuse future hackers".  Barring
objection, I'll go revert them.

			regards, tom lane





view thread (71+ messages)  latest in thread

Message-ID: <1050120.1745947158@sss.pgh.pa.us>
Permalink:  ../1050120.1745947158@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1050120.1745947158@sss.pgh.pa.us

 · 

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: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, peter@eisentraut.org, nathandbossart@gmail.com, andres@anarazel.de, simseih@amazon.com, pryzby@telsasoft.com
  Subject: Re: allow changing autovacuum_max_workers without restarting
  In-Reply-To: <1050120.1745947158@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