Обсуждение: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l

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.mshk@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.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(+)

On Tue, Dec 30, 2025 at 1:13 PM Masahiko Sawada <msawada@postgresql.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.mshk@gmail.com>
> Reviewed-by: Chao Li <li.evan.chao@gmail.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@gmail.com>

Regards,

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