More reliable nbtree detection of unsatisfiable RowCompare quals involving a leading NULL key/element

Title

Topic

Performance

Created

2024-12-24 17:16:49

Last modified

2025-01-07 15:45:14 (2 weeks, 2 days ago)

Latest email

2025-01-07 15:39:44 (2 weeks, 2 days ago)

Status

2025-01: Committed

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

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

Emails

More reliable nbtree detection of unsatisfiable RowCompare quals involving a leading NULL key/element: First at 2024-12-23 18:02:59 by Peter Geoghegan <pg at bowt.ie>
Latest at 2025-01-07 15:39:44 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v2-0001-Improve-nbtree-unsatisfiable-RowCompare-detection.patch) at 2024-12-27 22:03:12 from Peter Geoghegan <pg at bowt.ie>
Attachment (v2-0001-Improve-nbtree-unsatisfiable-RowCompare-detection.patch) at 2024-12-27 22:03:12 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
Attachment (v1-0001-nbtree-Detect-more-unsatisfiable-RowCompare-NULL-.patch) at 2024-12-23 18:02:59 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)

History

When	Who	What
2025-01-07 15:45:14	Peter Geoghegan (pgeoghegan)	Closed in commitfest 2025-01 with status: Committed
2025-01-07 15:45:14	Peter Geoghegan (pgeoghegan)	Changed committer to pgeoghegan
2024-12-24 17:17:07	Peter Geoghegan (pgeoghegan)	Changed authors to Peter Geoghegan (pgeoghegan)
2024-12-24 17:16:49	Peter Geoghegan (pgeoghegan)	Attached mail thread CAH2-WzmySVXst2hFrOATC-zw1Byg1XC-jYUS314=mzuqsNwk+Q@mail.gmail.com
2024-12-24 17:16:49	Peter Geoghegan (pgeoghegan)	Created patch record