model-writtenrun 8093 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Peter Eisentraut opened the thread by observing that VACUUM (PARALLEL 5) appeared capped by max_parallel_maintenance_workers, contrary to his reading of the documentation; Amit Kapila confirmed the cap and proposed clearer documentation in #1 and #2.
- Peter argued that an explicit PARALLEL value should override the configuration setting, while Amit defended the cap as consistent with other parallel operations and useful for controlling resource consumption in #3, #4, #5, #6, #7, and #8.
- David Rowley favored consistency with the limits on the parallel_workers table option, and Peter supported documenting precise worker-selection rules despite the behavioral disagreement in #9 and #11.
- Amit posted the sole patchset in #12, documenting that eligible indexes determine the worker count, which is limited by an explicit PARALLEL value and then by max_parallel_maintenance_workers.
- Robert Haas supported overriding the configuration setting because other VACUUM options override defaults, while Amit pointed out that CREATE INDEX also caps a requested worker count; Robert acknowledged the need for consistency in #13, #14, and #16.
- Masahiko Sawada proposed using the parallel_workers table option for default VACUUM parallelism while allowing explicit PARALLEL values to bypass the maintenance cap, but Robert opposed sharing settings between scans and maintenance, and Amit considered the proposal unnecessarily complex in #15, #17, and #18.
- Kyotaro Horiguchi raised privilege and capacity concerns about bypassing the cap and distinguished scan parallelism from vacuum parallelism; Masahiko noted that future parallel table scans would further complicate the design in #19 and #20.
- Amit separated the documentation correction from possible future behavior changes in #21, committed #12 unchanged as 560d260d78 with a PostgreSQL 13 backpatch, and announced completion in #22; the proposed behavior changes remained unimplemented.