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

On Tue, Dec 30, 2025 at 1:13 PM Masahiko Sawada <msawada(at)postgresql(dot)org> wrote:
>
> 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(+)
>

My apologies, I missed to credit the patch author:

Tatsuya Kawata <kawatatatsuya0913(at)gmail(dot)com>

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com