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 (1 year, 1 month ago)

Latest email 2023-10-07 17:42:51 (1 year, 1 month 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