Fix buffer pinning logic in [SP-]Gist

Title

CI (CFBot)

Needs rebase! Needs rebase since 1 week. Failing since 3 weeks.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Topic

Bug Fixes

Tags

Created

2025-02-05 10:06:48

Last modified

2025-05-07 16:56:15 (1 month ago)

Latest email

2025-04-24 20:46:10 (2 months ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Needs review

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-04-24 20:46:10 by Matthias van de Meent <boekewurm+postgres at gmail.com>
Latest 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>
    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
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