From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: VACUUM VERBOSE: Show dead items for an empty table. |
Date: | 2022-04-15 21:22:22 |
Message-ID: | E1nfTOY-000gTY-3T@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
VACUUM VERBOSE: Show dead items for an empty table.
Be consistent about the lines that VACUUM VERBOSE outputs by including
an "index scan not needed: " line for completely empty tables. This
makes the output more readable, especially with multiple distinct VACUUM
operations processed by the same VACUUM command. It's also more
consistent; even empty tables can use the failsafe, which wasn't
reported in the standard way until now.
Follow-up to commit 6e20f460, which taught VACUUM VERBOSE to be more
consistent about reporting on scanned pages with empty tables.
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/bdb71dbe80d0560f84255e05b73f449e11007325
Modified Files
--------------
src/backend/access/heap/vacuumlazy.c | 38 +++++++++++++++++-------------------
1 file changed, 18 insertions(+), 20 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-04-15 21:50:13 | pgsql: Tighten ComputeXidHorizons' handling of walsenders. |
Previous Message | Peter Geoghegan | 2022-04-15 20:23:40 | pgsql: Adjust VACUUM's removable cutoff log message. |