Optimise index range scan by performing first check with upper page boundary

Edit
ID 4434
Title Optimise index range scan by performing first check with upper page boundary
Topic Performance
Created 2023-07-02 05:39:59
Last modified 2023-10-18 10:31:36 (11 months, 3 weeks ago)
Latest email 2023-10-07 17:42:51 (1 year ago)
Status
2023-11: Committed
2023-09: Moved to next CF
2023-07: Moved to next CF
Target version 17
Authors Konstantin Knizhnik (knizhnik)
Reviewers Become reviewer
Committer Alexander Korotkov (smagen)
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/4434
git checkout commitfest/cf/4434
Emails
Index range search optimization
First at 2023-06-23 07:35:50 by Konstantin Knizhnik <knizhnik at garret.ru>
Latest at 2023-10-07 17:42:51 by Alexander Korotkov <aekorotkov at gmail.com>
Latest attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v8.patch) at 2023-09-29 06:35:24 from Alexander Korotkov <aekorotkov at gmail.com>
    Attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v8.patch) at 2023-09-29 06:35:24 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v7.patch) at 2023-09-27 16:41:31 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v6.patch) at 2023-09-25 10:18:04 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v5-0001-PATCH-Skip-checking-of-scan-keys-required-for-dir.patch) at 2023-09-25 10:11:53 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v4.patch) at 2023-09-25 09:58:02 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v4.patch) at 2023-09-22 14:24:40 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v3.patch) at 2023-09-21 09:14:17 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v2.patch) at 2023-09-20 14:07:28 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Skip-checking-of-scan-keys-required-for-direction-v1.patch) at 2023-09-14 10:22:50 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (range-search.patch) at 2023-06-23 07:35:50 from Konstantin Knizhnik <knizhnik at garret.ru> (Patch: Yes)
History
When Who What
2023-10-18 10:31:36 Alexander Korotkov (smagen) Closed in commitfest 2023-11 with status: Committed
2023-10-18 10:31:32 Alexander Korotkov (smagen) Changed committer to smagen
2023-10-18 10:31:32 Alexander Korotkov (smagen) Changed targetversion to 17
2023-10-02 09:47:09 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-02 08:23:34 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-02 05:40:23 Konstantin Knizhnik (knizhnik) Changed authors to Konstantin Knizhnik (knizhnik)
2023-07-02 05:39:59 Konstantin Knizhnik (knizhnik) Attached mail thread 079c3f8e-3371-abe2-e93c-fc8a0ae3f571@garret.ru
2023-07-02 05:39:59 Konstantin Knizhnik (knizhnik) Created patch record
Edit