On 2020-09-19 11:37, Amit Kapila wrote:
I think we can change the documentation for parallel option to explain it better. How about: "Perform index vacuum and index cleanup phases of VACUUM in parallel using integer background workers (for the details of each vacuum phase, please refer to Table 27.37). The number of workers is determined based on the number of indexes on the relation that support parallel vacuum operation which is limited by number of workers specified with PARALLEL option if any which is further limited by max_parallel_maintenance_workers." instead of what is currently there?
I think the implemented behavior is wrong. The VACUUM PARALLEL option should override the max_parallel_maintenance_worker setting.
Otherwise, what's the point of the command option? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
