pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l

From: Masahiko Sawada <msawada(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
Date: 2025-12-30 21:13:17
Message-ID: E1vah1o-003Xfj-2z@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add dead items memory usage to VACUUM (VERBOSE) and autovacuum logs.

This commit adds the total memory allocated during vacuum, the number
of times the dead items storage was reset, and the configured memory
limit. This helps users understand how much memory VACUUM required,
and such information can be used to avoid multiple index scans.

Reviewed-by: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/CAHza6qcPitBCkyiKJosDTt3bmxMvzZOTONoebwCkBZrr3rk65Q%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/736f754eed01ca81198b6cd7421321088cbe5ded

Modified Files
--------------
src/backend/access/heap/vacuumlazy.c | 33 +++++++++++++++++++++++++++++++++
1 file changed, 33 insertions(+)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Masahiko Sawada 2025-12-30 21:17:08 Re: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
Previous Message Masahiko Sawada 2025-12-30 18:58:41 pgsql: Fix a race condition in updating procArray->replication_slot_xmi