Adding support for Row Compares to nbtree startikey optimization

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 1, First patch: +133−32, All patches: +133−32

Topic

Performance

Tags

Created

2025-07-06 02:20:20

Last modified

2025-09-15 21:03:15 (1 month ago)

Latest email

2025-09-15 03:00:09 (1 month ago)

Status

PG19-2 (2025-09-01 – 2025-09-30): Committed

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

Committer

Peter Geoghegan (pgeoghegan)

Links

Emails

Adding support for Row Compares to nbtree startikey optimization: First at 2025-07-06 02:19:10 by Peter Geoghegan <pg at bowt.ie>
Latest at 2025-09-15 03:00:09 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v2-0001-Teach-nbtree-to-avoid-evaluating-row-compare-keys.patch) at 2025-09-15 03:00:09 from Peter Geoghegan <pg at bowt.ie>
Attachment (v2-0001-Teach-nbtree-to-avoid-evaluating-row-compare-keys.patch) at 2025-09-15 03:00:09 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
Attachment (v1-0001-Teach-nbtree-to-set-pstate.ikey-beyond-a-row-comp.patch) at 2025-07-06 02:19:10 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)

History

When	Who	What
2025-09-15 21:03:15	Peter Geoghegan (pgeoghegan)	Closed in commitfest PG19-2 with status: Committed
2025-09-15 21:03:15	Peter Geoghegan (pgeoghegan)	Changed committer to pgeoghegan
2025-08-15 06:37:31	Chao Li (chaol)	Posted comment with messageid <175523985114.994.399192844268418577.pgcf@coridan.postgresql.org>
2025-08-15 06:37:31	Chao Li (chaol)	New status: Waiting on Author
2025-08-15 06:31:42	Chao Li (chaol)	Added chaol as reviewer
2025-07-06 02:20:20	Peter Geoghegan (pgeoghegan)	Attached mail thread CAH2-WznL6Z3H_GTQze9d8T_Ls=cYbnd-_9f-Jo7aYgTGRUD58g@mail.gmail.com
2025-07-06 02:20:20	Peter Geoghegan (pgeoghegan)	Created patch record