pgsql: Make SP-GiST redirect cleanup more aggressive.

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Make SP-GiST redirect cleanup more aggressive.
Date: 2023-04-03 18:48:22
Message-ID: E1pjPE5-001CWl-7x@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Make SP-GiST redirect cleanup more aggressive.

Commit 61b313e4 made VACUUM pass down a heaprel to index AM bulkdelete
and vacuumcleanup routines. Although this was primarily intended as
preparation for logical decoding on standbys, it also made it easy to
correct an old deficiency in how we determine how to cleanup SP-GiST
redirect and placeholder tuples.

Pass the heaprel to GlobalVisTestFor() during cleanup of redirect and
placeholder tuples, rather than pessimistically passing NULL.

Author: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
Discussion: https://postgr.es/m/02392033-f030-a3c8-c7d0-5c27eb529fec@gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/05a304a855104a8eb6394e044bfbc8e761a4d635

Modified Files
--------------
src/backend/access/spgist/spgvacuum.c | 3 +--
1 file changed, 1 insertion(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2023-04-04 01:19:19 pgsql: bufmgr: Remove buffer-write-dirty tracepoints
Previous Message Peter Geoghegan 2023-04-03 18:31:59 pgsql: Recycle deleted nbtree pages more aggressively.