Optimizing "boundary cases" during backward scan B-Tree index descents

Title

Topic

Performance

Created

2023-06-21 00:13:25

Last modified

2023-12-08 19:06:48 (11 months, 3 weeks ago)

Latest email

2023-11-06 13:16:09 (1 year ago)

Status

2024-01: Committed

2023-11: Moved to next CF

2023-09: Moved to next CF

2023-07: Moved to next CF

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

Matthias van de Meent (mmeent)Become reviewer

Committer

Peter Geoghegan (pgeoghegan)

Links

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/4380
git checkout commitfest/cf/4380

Emails

Optimizing "boundary cases" during backward scan B-Tree index descents: First at 2023-06-19 23:28:38 by Peter Geoghegan <pg at bowt.ie>
Latest at 2023-11-06 13:16:09 by Matthias van de Meent <boekewurm+postgres at gmail.com>
Latest attachment (v4-0001-Optimize-nbtree-backward-scan-boundary-cases.patch) at 2023-10-15 20:54:25 from Peter Geoghegan <pg at bowt.ie>
    Attachment (v4-0001-Optimize-nbtree-backward-scan-boundary-cases.patch) at 2023-10-15 20:54:25 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v3-0001-Optimize-nbtree-backward-scan-boundary-cases.patch) at 2023-09-18 23:58:47 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v2-0001-Optimize-nbtree-backward-scan-boundary-cases.patch) at 2023-06-21 00:12:10 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Add-nbtree-goback-boundary-case-optimization.patch) at 2023-06-19 23:28:38 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)

History

When	Who	What
2023-12-08 19:06:48	Peter Geoghegan (pgeoghegan)	Closed in commitfest 2024-01 with status: Committed
2023-12-08 19:06:48	Peter Geoghegan (pgeoghegan)	Changed committer to pgeoghegan
2023-12-04 09:46:17	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-28 13:49:21	Matthias van de Meent (mmeent)	New status: Waiting on Author
2023-11-06 17:19:20	Matthias van de Meent (mmeent)	Added mmeent as reviewer
2023-10-02 09:46:55	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-03 08:09:09	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2023-07 with status: Moved to next CF
2023-06-21 00:13:41	Peter Geoghegan (pgeoghegan)	Changed authors to Peter Geoghegan (pgeoghegan)
2023-06-21 00:13:41	Peter Geoghegan (pgeoghegan)	Changed targetversion to 17
2023-06-21 00:13:25	Peter Geoghegan (pgeoghegan)	Attached mail thread CAH2-Wz=XPzM8HzaLPq278Vms420mVSHfgs9wi5tjFKHcapZCEw@mail.gmail.com
2023-06-21 00:13:25	Peter Geoghegan (pgeoghegan)	Created patch record