pgsql: VACUUM VERBOSE: Show dead items for an empty table.

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(-)

Browse pgsql-committers by date

  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.