Re: allow changing autovacuum_max_workers without restarting

Nathan Bossart <nathandbossart@gmail.com>

View thread

From: Nathan Bossart <nathandbossart@gmail.com>

To: "Imseih (AWS), Sami" <simseih@amazon.com>

Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2024-04-14T14:40:58Z

Lists: pgsql-hackers

Attachments

v1-0001-Rename-autovacuum_max_workers-to-autovacuum_max_w.patch (text/x-diff)

Here is a first attempt at a proper patch set based on the discussion thus
far.  I've split it up into several small patches for ease of review, which
is probably a bit excessive.  If this ever makes it to commit, they could
likely be combined.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com

Commits

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

Give up on running with NetBSD/OpenBSD's default semaphore settings.
- 810a8b1c8051 18.0 landed
initdb: Do not report default autovacuum_worker_slots.
- 2b49492eda3f 18.0 landed
Lower default value of autovacuum_worker_slots in initdb as needed.
- 6d01541960e2 18.0 landed
Allow changing autovacuum_max_workers without restarting.
- c758119e5bfb 18.0 landed
Reserve a PGPROC slot and semaphore for the slotsync worker process.
- 2bdf1b2a2efc 18.0 cited
Make archiver process an auxiliary process.
- d75288fb27b8 14.0 cited
Correct the formulas for System V IPC parameters SEMMNI and SEMMNS in docs.
- 597f7e3a6ec3 9.6.0 cited