pgsql: Add parallel vacuum worker usage to VACUUM (VERBOSE) and autovac - Mailing list pgsql-committers

From Masahiko Sawada
Subject pgsql: Add parallel vacuum worker usage to VACUUM (VERBOSE) and autovac
Date
Msg-id E1w3LSK-000YH9-30@gemulon.postgresql.org
Whole thread Raw
List 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@gmail.com>
Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com>
Reviewed-by: Sami Imseih <samimseih@gmail.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(-)


pgsql-committers by date:

Previous
From: Masahiko Sawada
Date:
Subject: pgsql: Allow explicit casting between bytea and uuid.
Next
From: Jeff Davis
Date:
Subject: pgsql: Fix dependency on FDW handler.