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

Title

Topic

Performance

Created

2023-07-02 05:39:59

Last modified

2023-08-02 08:23:34 (1 month, 3 weeks ago)

Latest email

2023-09-29 01:57:07 (4 hours, 38 minutes ago)

Status

2023-09: Needs review

2023-07: Moved to next CF

Target version

Authors

Konstantin Knizhnik (knizhnik)

Reviewers

Become reviewer

Committer

Links

Emails

Index range search optimization: First at 2023-06-23 07:35:50 by Konstantin Knizhnik <knizhnik at garret.ru>
Latest at 2023-09-29 01:57:07 by Peter Geoghegan <pg at bowt.ie>
Latest 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>
    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-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