Horton
Menu

Re: allow changing autovacuum_max_workers without restarting

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Peter Eisentraut <peter@eisentraut.org>, Andres Freund <andres@anarazel.de>, pgsql-hackers@lists.postgresql.org, "Imseih (AWS), Sami" <simseih@amazon.com>, Justin Pryzby <pryzby@telsasoft.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2025-04-29T21:31:01Z
Lists: pgsql-hackers 
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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Give up on running with NetBSD/OpenBSD's default semaphore settings.

  2. initdb: Do not report default autovacuum_worker_slots.

  3. Lower default value of autovacuum_worker_slots in initdb as needed.

  4. Allow changing autovacuum_max_workers without restarting.

  5. Reserve a PGPROC slot and semaphore for the slotsync worker process.

  6. Make archiver process an auxiliary process.

  7. Correct the formulas for System V IPC parameters SEMMNI and SEMMNS in docs.