Hi, I noticed that we don't honor a reduced number of parallel workers for parallel autovacuum. This means a lowered autovacuum_max_parallel_workers can't take effect after a long heap scan phase on a table of hundreds of GBs or even TBs. Note that we can only downsize, upsizing is not possible because the DSM is sized in parallel_vacuum_init() before the heap scan phase of the vacuum.
Please find the attached patch fixing this. Thoughts? -- Bharath Rupireddy Amazon Web Services: https://aws.amazon.com
v1-0001-Honor-reduced-workers-after-heap-scan-phase-for-p.patch
Description: Binary data
