Fix buffer pinning logic in [SP-]Gist

Edit

5542

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v12, Patch count: 5, First patch: +430−82, All patches: +1429−140

Topic

Bug Fixes

Created

2025-02-05 10:06:48

Last modified

2025-05-07 16:56:15 (yesterday)

Latest email

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

Status

2025-07: Needs review

2025-03: Moved to next CF

Target version

Authors

Peter Geoghegan (pgeoghegan), Michail Nikolaev (nkey), Matthias van de Meent (mmeent), 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-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