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-10-18 10:31:36 (6 months, 1 week ago)

Latest email

2023-10-07 17:42:51 (6 months, 3 weeks ago)

Status

2023-11: Committed

2023-09: Moved to next CF

2023-07: Moved to next CF

Target version

Authors

Konstantin Knizhnik (knizhnik)

Reviewers

Become reviewer

Committer

Alexander Korotkov (smagen)

Links

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