pgsql: Add parallel vacuum worker usage to VACUUM (VERBOSE) and autovac

From: Masahiko Sawada <msawada(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add parallel vacuum worker usage to VACUUM (VERBOSE) and autovac
Date: 2026-03-19 22:03:05
Message-ID: E1w3LSK-000YH9-30@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add parallel vacuum worker usage to VACUUM (VERBOSE) and autovacuum logs.

This commit adds both the number of parallel workers planned and the
number of parallel workers actually launched to the output of
VACUUM (VERBOSE) and autovacuum logs.

Previously, this information was only reported as an INFO message
during VACUUM (VERBOSE), which meant it was not included in autovacuum
logs in practice. Although autovacuum does not yet support parallel
vacuum, a subsequent patch will enable it and utilize these logs in
its regression tests. This change also improves observability by
making it easier to verify if parallel vacuum is utilizing the
expected number of workers.

Author: Daniil Davydov <3danissimo(at)gmail(dot)com>
Reviewed-by: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Reviewed-by: Sami Imseih <samimseih(at)gmail(dot)com>
Discussion: https://postgr.es/m/CACG=ezZOrNsuLoETLD1gAswZMuH2nGGq7Ogcc0QOE5hhWaw=cw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/adcdbe93860b16a069c6834062e56e731c54a1a1

Modified Files
--------------
src/backend/access/heap/vacuumlazy.c | 31 +++++++++++++++++++++++++++++--
src/backend/commands/vacuumparallel.c | 23 +++++++++++++++++------
src/include/commands/vacuum.h | 28 ++++++++++++++++++++++++++--
src/tools/pgindent/typedefs.list | 2 ++
4 files changed, 74 insertions(+), 10 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Jeff Davis 2026-03-19 22:08:01 pgsql: Fix dependency on FDW handler.
Previous Message Masahiko Sawada 2026-03-19 20:52:09 pgsql: Allow explicit casting between bytea and uuid.