Re: [PATCH] Add memory usage reporting to VACUUM VERBOSE - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: [PATCH] Add memory usage reporting to VACUUM VERBOSE
Date
Msg-id CAD21AoDX+z5Bo5z7qdY4BFaEcQYJXoe+_2k6qMPX=pYfrxDunw@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Add memory usage reporting to VACUUM VERBOSE  (河田達也 <kawatatatsuya0913@gmail.com>)
Responses Re: [PATCH] Add memory usage reporting to VACUUM VERBOSE
List pgsql-hackers
On Fri, Nov 21, 2025 at 8:26 AM 河田達也 <kawatatatsuya0913@gmail.com> wrote:
>
> Hi Sawada-san,
>
> Thank you for your additional feedback on v4!
>
> >We can initialize dead_items_max_bytes when declared.
> Thank you. I fixed it as you mentioned.
>
> >Does it need to check if vacrel->dead_items is non-NULL?
> Thank you. I fixed it as you mentioned.
>
> >I think we should not use "index scans" since the number doesn't
> >actually represent the number of index scans performed. How about
> >something like:
> >
> >memory usage: 1.02 MB in total, with dead-item storage reset 15 times
> >(limit was 0.06 MB)
> >
> >Also when it comes to the plural, we can use errmsg_plural() instead.
> Thank you. I fixed the message as you mentioned.

Thank you for updating the patch!

> Also, I found that ngettext() with appendStringInfo() is a standard pattern
> in the PostgreSQL codebase (e.g., src/backend/catalog/pg_shdepend.c,
> src/backend/catalog/dependency.c), so I use ngettext() in this code.

You're right. We should use ngettext() instead.

The patch basically looks good to me. I've made some cosmetic changes
to the v5 patch and attached it as a separate patch. Most of the
changes are to remove redundant comments (because it's obvious from
the codes) and rephrasing the comments. Please review it.

Regards,

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

Attachment

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: pgsql: Teach DSM registry to ERROR if attaching to an uninitialized ent
Next
From: Peter Geoghegan
Date:
Subject: Re: index prefetching