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

From Masahiko Sawada
Subject pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
Date
Msg-id E1vah1o-003Xfj-2z@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l
List pgsql-committers
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(+)


pgsql-committers by date:

Previous
From: Masahiko Sawada
Date:
Subject: pgsql: Fix a race condition in updating procArray->replication_slot_xmi
Next
From: Masahiko Sawada
Date:
Subject: Re: pgsql: Add dead items memory usage to VACUUM (VERBOSE) and autovacuum l