Avoiding superfluous buffer locking during nbtree backwards scans

5222

Title

Topic

Performance

Created

2024-08-30 19:46:13

Last modified

2024-10-18 20:13:41 (1 month ago)

Latest email

2024-11-13 14:51:47 (1 week ago)

Status

2024-11: Committed

2024-09: Moved to next CF

Target version

Authors

Matthias van de Meent (mmeent)

Reviewers

Become reviewer

Committer

Peter Geoghegan (pgeoghegan)

Links

CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5222
git checkout commitfest/cf/5222

Emails

Avoiding superfluous buffer locking during nbtree backwards scans: First at 2024-07-05 16:47:49 by Peter Geoghegan <pg at bowt.ie>
Latest at 2024-11-13 14:51:47 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v1-0001-Use-_bt_returnitem-wrapper-function.patch) at 2024-11-12 15:55:02 from Peter Geoghegan <pg at bowt.ie>
    Attachment (v1-0001-Use-_bt_returnitem-wrapper-function.patch) at 2024-11-12 15:55:02 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v2-0001-Fix-confusion-with-nbtree-parallel-scan-currPos-s.patch) at 2024-11-07 22:42:47 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Fix-confusion-with-nbtree-parallel-scan-currPos-s.patch) at 2024-11-07 19:19:32 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v6-0001-Optimize-and-simplify-nbtree-backwards-scans.patch) at 2024-10-16 18:02:42 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v5-0001-Optimize-and-simplify-nbtree-backwards-scans.patch) at 2024-10-11 23:29:12 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v4-0001-Optimize-and-simplify-nbtree-backwards-scans.patch) at 2024-10-10 17:41:13 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v3-0001-Avoid-unneeded-nbtree-backwards-scan-buffer-locks.patch) at 2024-09-02 11:31:55 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Avoid-unneeded-nbtree-backwards-scan-buffer-locks.patch) at 2024-08-30 19:43:22 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Avoid-unneeded-nbtree-backwards-scan-buffer-locks.patch) at 2024-08-19 11:43:35 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Avoid-unneeded-nbtree-backwards-scan-buffer-lock.patch) at 2024-07-05 16:47:49 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)

History

When	Who	What
2024-10-18 20:13:41	Peter Geoghegan (pgeoghegan)	Closed in commitfest 2024-11 with status: Committed
2024-10-18 20:13:41	Peter Geoghegan (pgeoghegan)	Changed committer to pgeoghegan
2024-10-08 02:14:21	Michael Paquier (michael-kun)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-30 19:46:23	Matthias van de Meent (mmeent)	Changed authors to Matthias van de Meent (mmeent)
2024-08-30 19:46:13	Matthias van de Meent (mmeent)	Attached mail thread CAH2-Wz=xgs7PojG=EUvhgadwENzu_mY_riNh-w9wFPsaS717ew@mail.gmail.com
2024-08-30 19:46:13	Matthias van de Meent (mmeent)	Created patch record