Re: allow changing autovacuum_max_workers without restarting

Yogesh Sharma <yogesh.sharma@catprosystems.com>

From: Yogesh Sharma <yogesh.sharma@catprosystems.com>

To: pgsql-hackers@lists.postgresql.org

Cc: Nathan Bossart <nathandbossart@gmail.com>

Date: 2024-11-20T14:48:58Z

Lists: pgsql-hackers

The following review has been posted through the commitfest application:
make installcheck-world:  tested, failed
Implements feature:       tested, failed
Spec compliant:           tested, failed
Documentation:            not tested

Hi,
- Tested patch with check-world.
- Verified CheckAutovacuumWorkerGUCs functionality and the correct WARNING was reported.
- For feature specific testing, I created multiple tables and generated bloat. Expected behavior was witnessed.
Lower autovacuum_worker_slots = 16 setting is better suited to start with.

Thanks
Yogesh

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