Horton

VACUUM PARALLEL option vs. max_parallel_maintenance_workers

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-09-19T08:28:59Z
Lists: pgsql-hackers 
If I read the code correctly, the VACUUM PARALLEL option is capped by 
the active max_parallel_maintenance_workers setting.  So if I write 
VACUUM (PARALLEL 5), it will still only do 2 by default.  Is that 
correct?  The documentation (VACUUM man page) seems to indicate a 
different behavior.

I haven't been able to set up something to test or verify this either way.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Change the docs for PARALLEL option of Vacuum.