max_parallel_maintenance_workers additional clarification regarding autovacuum

Started by Matthew Gwillamover 2 years ago1 messagesdocs
Beta feature

Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.

appliessuccessCI history

You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:

docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t77554
psql -h localhost -U postgres

Built from patchset v1 (message #1), August 17, 2026 at 10:04 AM.

Jump to latest
#1Matthew Gwillam
matt.gwillam@hotmail.co.uk

Hi team,

Attaching a proposed patch to make it more explicit that max_parallel_maintenance_workers does not apply to autovacuum, which does not use parallelism. I personally believe that this could be made clearer.

Sources of autovacuum not running parallelism:

1)
postgres/src/backend/postmaster/autovacuum.c, line 2913 at time of writing:

/* As of now, we don't support parallel vacuum for autovacuum */

2)
https://www.2ndquadrant.com/en/blog/parallelism-comes-to-vacuum/ - "Parallel vacuum is always disabled in autovacuum.""

Best regards,

Matthew

Attachments:

max-parallel-workers-doc-change-v1.patchtext/x-patch; name=max-parallel-workers-doc-change-v1.patchDownload+1-1