pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
2+ messages / 2 participants
[nested] [flat]
* pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
@ 2025-12-30 21:13 Masahiko Sawada <msawada@postgresql.org>
2025-12-30 21:17 ` Re: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l Masahiko Sawada <sawada.mshk@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Masahiko Sawada @ 2025-12-30 21:13 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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%40mai...
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/736f754eed01ca81198b6cd7421321088cbe5ded
Modified Files
--------------
src/backend/access/heap/vacuumlazy.c | 33 +++++++++++++++++++++++++++++++++
1 file changed, 33 insertions(+)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
2025-12-30 21:13 pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l Masahiko Sawada <msawada@postgresql.org>
@ 2025-12-30 21:17 ` Masahiko Sawada <sawada.mshk@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Masahiko Sawada @ 2025-12-30 21:17 UTC (permalink / raw)
To: Masahiko Sawada <msawada@postgresql.org>; +Cc: pgsql-committers@lists.postgresql.org
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%40mai...
>
> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-12-30 21:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-12-30 21:13 pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l Masahiko Sawada <msawada@postgresql.org>
2025-12-30 21:17 ` Masahiko Sawada <sawada.mshk@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox