Обсуждение: max_parallel_maintenance_workers additional clarification regarding autovacuum

Поиск
Список
Период
Сортировка

max_parallel_maintenance_workers additional clarification regarding autovacuum

От
Matthew Gwillam
Дата:
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

Вложения