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

From Masahiko Sawada
Subject Re: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
Date
Msg-id CAD21AoD8NOPCZ6_b0Kt1rdaMtwSU2PaAhwcecEBj4ifEySvLRw@mail.gmail.com
Whole thread Raw
In response to pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l  (Masahiko Sawada <msawada@postgresql.org>)
List pgsql-committers
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



pgsql-committers by date:

Previous
From: Masahiko Sawada
Date:
Subject: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
Next
From: Tom Lane
Date:
Subject: pgsql: Change IndexAmRoutines to be statically-allocated structs.