| From: | Matthew Gwillam <matt(dot)gwillam(at)hotmail(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
| Subject: | max_parallel_maintenance_workers additional clarification regarding autovacuum |
| Date: | 2024-01-07 14:54:36 |
| Message-ID: | AS8P193MB1176C2ED539AB847610F9573C5642@AS8P193MB1176.EURP193.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| Attachment | Content-Type | Size |
|---|---|---|
| max-parallel-workers-doc-change-v1.patch | text/x-patch | 879 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2024-01-08 13:31:36 | Grammar suggestion |
| Previous Message | Tom Lane | 2024-01-07 04:27:14 | Re: initdb username doc bug |