| 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: | Whole Thread | Raw Message | 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. |