Fix buffer pinning logic/visibility bugs in [SP-]Gist Index-Only Scans

Edit
ID 5542
Title Fix buffer pinning logic/visibility bugs in [SP-]Gist Index-Only Scans
CI (CFBot) Needs rebase! Needs rebase since 3 weeks. Failing since 3 weeks.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags Bugfix
Created 2025-02-05 10:06:48
Last modified 2026-02-03 22:09:55 (1 hour ago)
Latest email 2025-12-22 22:23:05 (1 month ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-Drafts (2025-06-22 – 2026-02-28): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
Target version
Authors Matthias van de Meent (mmeent), Peter Geoghegan (pgeoghegan), Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
Reviewers Become reviewer
Committer
Links
Emails
Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM?
First at 2021-11-03 23:33:08 by Peter Geoghegan <pg at bowt.ie>
Latest at 2025-12-24 11:54:48 by Matthias van de Meent <boekewurm+postgres at gmail.com>
Latest attachment (v14-0007-nbtree-Reduce-Index-Only-Scan-pin-duration.patch) at 2025-12-24 11:54:48 from Matthias van de Meent <boekewurm+postgres at gmail.com>
    Attachment (v14-0007-nbtree-Reduce-Index-Only-Scan-pin-duration.patch) at 2025-12-24 11:54:48 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Add-vectorized-API-for-visibility-map-lookup.patch) at 2025-12-22 22:23:05 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v12-0002-GIST-Fix-visibility-issues-in-IOS.patch) at 2025-04-24 20:46:10 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v10-0004-NBTree-Reduce-Index-Only-Scan-pinning-requiremen.patch) at 2025-03-21 16:14:12 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v9-0001-IOS-TableAM-Support-AM-supplied-fast-visibility-c.patch) at 2025-03-08 02:36:31 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Fix-index-only-scan-race-condition-in-GiST-implem.patch) at 2025-02-08 13:46:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v7-0004-This-should-fix-issues-with-incorrect-results-whe.patch) at 2025-02-05 10:11:40 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v6-0003-This-should-fix-issues-with-incorrect-results-whe.patch) at 2025-02-05 10:04:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v5-0002-RFC-Extend-buffer-pinning-for-GIST-IOS.patch) at 2025-01-10 17:06:10 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v4-0001-isolationtester-showing-broken-index-only-scans-w.patch) at 2025-01-06 23:45:18 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v3-0001-isolationtester-showing-broken-index-only-scans-w.patch) at 2025-01-04 01:00:34 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v2-0001-isolationtester-showing-broken-index-only-scans-w.patch) at 2024-12-03 01:18:14 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-nbtree-README-Improve-VACUUM-interlock-section.patch) at 2021-12-01 01:09:14 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (unknown_filename) at 2021-11-04 15:52:22 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: No)
History
When Who What
2026-02-03 22:09:55 Álvaro Herrera (alvherre) Moved from CF PG19-4 to CF PG19-Final
2026-01-12 17:24:27 CFbot Patch needs rebase
2025-12-24 21:58:03 Matthias van de Meent (mmeent) Changed name to Fix buffer pinning logic/visibility bugs in [SP-]Gist Index-Only Scans
2025-12-22 23:26:32 CFbot Patch does not need rebase anymore
2025-12-22 23:19:36 Matthias van de Meent (mmeent) Moved from CF PG19-Drafts to CF PG19-4
2025-09-04 14:19:14 Mihail Nikalayeu (mihailnikalayeu) Moved from CF PG19-1 to CF PG19-Drafts
2025-06-17 22:41:45 CFbot Patch needs rebase
2025-05-07 16:56:15 Matthias van de Meent (mmeent) New status: Needs review
2025-05-04 13:46:55 Michail Nikolaev (nkey) Changed authors to Peter Geoghegan (pgeoghegan), Michail Nikolaev (nkey), Matthias van de Meent (mmeent), Mihail Nikalayeu (mihailnikalayeu)
2025-04-24 21:01:44 CFbot Patch does not need rebase anymore
2025-04-20 19:45:40 Mihail Nikalayeu (mihailnikalayeu) Closed in commitfest 2025-03 with status: Moved to next CF
2025-04-01 06:51:41 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-24 04:26:41 CFbot Patch needs rebase
2025-03-22 20:25:57 Matthias van de Meent (mmeent) New status: Needs review
2025-03-16 12:58:24 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-03 17:57:54 Matthias van de Meent (mmeent) Changed name to Fix buffer pinning logic in [SP-]Gist
2025-02-05 10:07:59 Michail Nikolaev (nkey) Changed authors to Peter Geoghegan (pgeoghegan), Michail Nikolaev (nkey), Matthias van de Meent (mmeent)
2025-02-05 10:06:49 Michail Nikolaev (nkey) Attached mail thread CAH2-Wz=PqOziyRSrnN5jAtfXWXY7-BJcHz9S355LH8Dt=5qxWQ@mail.gmail.com
2025-02-05 10:06:48 Michail Nikolaev (nkey) Created patch record
Edit