pgsql: Make SP-GiST redirect cleanup more aggressive. - Mailing list pgsql-committers

From Peter Geoghegan
Subject pgsql: Make SP-GiST redirect cleanup more aggressive.
Date
Msg-id E1pjPE5-001CWl-7x@gemulon.postgresql.org
Whole thread Raw
List 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.pg@gmail.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(-)


pgsql-committers by date:

Previous
From: Peter Geoghegan
Date:
Subject: pgsql: Recycle deleted nbtree pages more aggressively.
Next
From: Andres Freund
Date:
Subject: pgsql: bufmgr: Remove buffer-write-dirty tracepoints