Index Skip Scan

Edit
ID 1741
Title Index Skip Scan
Topic Server Features
Created 2018-08-01 10:58:28
Last modified 2022-03-24 11:32:49 (2 years, 8 months ago)
Latest email 2022-03-29 03:19:15 (2 years, 8 months ago)
Status
2022-03: Returned with feedback
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
2020-03: Moved to next CF
2020-01: Moved to next CF
2019-11: Moved to next CF
2019-09: Moved to next CF
2019-07: Moved to next CF
2019-03: Moved to next CF
2019-01: Moved to next CF
2018-11: Moved to next CF
2018-09: Moved to next CF
Target version 16
Authors Dmitry Dolgov (erthalion), Thomas Munro (macdice), Jesper Pedersen (jpedersen)
Reviewers Dilip Kumar (dilip.kumar), James Coleman (jcole1989), Peter Geoghegan (pgeoghegan), Cristiano Duarte (cunha17), Andy Fan (andyf), Yuming Wang (yumwang), Jet Zhang (thinkj), Alexandre Felipe (bob.tpro), Chris Travers (einhverfr), Thomas Munro (macdice)Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub Git
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/1741
git checkout commitfest/cf/1741
Emails
Index Skip Scan
First at 2018-06-18 15:25:39 by Jesper Pedersen <jesper.pedersen at redhat.com>
Latest at 2019-11-15 15:05:51 by Jesper Pedersen <jesper.pedersen at redhat.com>
Latest attachment (v30_0001-Unique-key.patch) at 2019-11-15 15:05:51 from Jesper Pedersen <jesper.pedersen at redhat.com>
    Attachment (v30_0001-Unique-key.patch) at 2019-11-15 15:05:51 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (v29_0001-Unique-key.patch) at 2019-11-11 18:24:51 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (skipscan-review.patch) at 2019-11-10 21:18:32 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (v28-0001-Index-skip-scan.patch) at 2019-11-07 15:43:58 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Index-skip-scan.patch) at 2019-09-25 09:34:22 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Index-skip-scan.patch) at 2019-09-22 13:45:01 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Index-skip-scan.patch) at 2019-09-05 19:20:06 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Index-skip-scan.patch) at 2019-08-28 15:53:59 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v23_0001-Unique-key.patch) at 2019-08-02 16:03:09 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (v22-0001-Index-skip-scan.patch) at 2019-07-24 20:49:32 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v2_uniquekey.txt) at 2019-07-16 16:53:53 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (uniquekey.txt) at 2019-07-09 13:32:16 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (v21-0001-Index-skip-scan.patch) at 2019-07-05 10:54:40 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0012-Index-scan-positioning-DEBUG1-instrumentation.patch) at 2019-06-23 01:01:57 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v20-0001-Index-skip-scan.patch) at 2019-06-20 13:20:39 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (v18-0001-Index-skip-scan.patch) at 2019-06-19 13:57:29 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Index-skip-scan.patch) at 2019-06-13 16:31:54 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (v17-0001-Index-skip-scan.patch) at 2019-06-03 20:31:33 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Index-skip-scan.patch) at 2019-05-29 15:50:51 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Index-skip-scan.patch) at 2019-05-11 16:35:41 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Index-skip-scan.patch) at 2019-03-28 10:01:24 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Index-skip-scan.patch) at 2019-03-19 13:07:32 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Index-skip-scan.patch) at 2019-03-16 16:14:20 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Index-skip-scan.patch) at 2019-03-14 13:32:49 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Index-skip-scan.patch) at 2019-03-05 15:05:42 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Index-skip-scan.patch) at 2019-02-20 16:35:08 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Index-skip-scan-v8.patch) at 2019-01-30 17:19:05 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Index-skip-scan-v7.patch) at 2019-01-27 17:17:46 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Index-skip-scan-v6.patch) at 2019-01-26 17:45:54 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Index-skip-scan-v5.patch) at 2018-11-21 20:56:34 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Index-skip-scan-v4.patch) at 2018-11-17 23:27:07 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Index-skip-scan-with-fallback-v3.patch) at 2018-11-14 16:48:47 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (index-skip-fallback-v2.patch) at 2018-10-16 19:22:18 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (index-skip-fallback.patch) at 2018-09-15 19:52:39 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (test-skip.sql) at 2018-09-13 13:01:13 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: No)
    Attachment (wip_indexskipscan_v2.patch) at 2018-09-11 13:21:57 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (wip_indexskipscan.patch) at 2018-06-18 15:25:39 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
RE: Index Skip Scan
First at 2020-01-15 13:33:41 by Floris Van Nee <florisvannee at Optiver.com>
Latest at 2020-06-02 23:17:59 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest attachment (v33-0001-Unique-key.patch) at 2020-04-07 19:42:20 from Dmitry Dolgov <9erthalion6 at gmail.com>
    Attachment (v33-0001-Unique-key.patch) at 2020-04-07 19:42:20 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Unique-key.patch) at 2020-03-25 08:51:00 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Unique-key.patch) at 2020-03-24 16:39:19 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Unique-key.patch) at 2020-03-22 12:55:29 from Floris Van Nee <florisvannee at Optiver.com> (Patch: Yes)
    Attachment (0001-Unique-key.patch) at 2020-03-21 22:00:01 from Floris Van Nee <florisvannee at Optiver.com> (Patch: Yes)
    Attachment (v32-0001-Unique-key.patch) at 2020-02-17 16:24:51 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Unique-key.patch) at 2020-02-07 16:25:43 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Unique-key.patch) at 2020-01-27 10:30:16 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (buffer_locked.txt) at 2020-01-21 17:06:12 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (v31_0001-Unique-key.patch) at 2020-01-20 19:01:20 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
Index Skip Scan (new UniqueKeys)
First at 2020-06-09 10:22:47 by Dmitry Dolgov <9erthalion6 at gmail.com>
Latest at 2022-03-24 11:39:31 by Jesper Pedersen <jesper.pedersen at redhat.com>
Latest attachment (v40-0001-Unique-expressions.patch) at 2022-01-22 21:31:33 from Dmitry Dolgov <9erthalion6 at gmail.com>
    Attachment (v40-0001-Unique-expressions.patch) at 2022-01-22 21:31:33 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v39-0001-Unique-expressions.patch) at 2021-05-21 15:31:38 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Introduce-RelOptInfo-notnullattrs-attribute-20210317.patch) at 2021-03-17 02:28:00 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v38-0001-Introduce-RelOptInfo-notnullattrs-attribute.patch) at 2021-03-14 14:48:33 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (index-skipscan-bug.sql) at 2020-11-30 14:42:20 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: No)
    Attachment (v37-0001-Introduce-RelOptInfo-notnullattrs-attribute.patch) at 2020-10-24 16:45:53 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v36-0001-Introduce-RelOptInfo-notnullattrs-attribute.patch) at 2020-08-15 14:12:40 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Introduce-RelOptInfo-notnullattrs-attribute.patch) at 2020-07-12 22:18:26 from Floris Van Nee <florisvannee at Optiver.com> (Patch: Yes)
    Attachment (0001-Introduce-RelOptInfo-notnullattrs-attribute.patch) at 2020-07-12 12:48:47 from Floris Van Nee <florisvannee at Optiver.com> (Patch: Yes)
    Attachment (v8-0001-Introduce-RelOptInfo-notnullattrs-attribute.patch) at 2020-06-09 10:22:47 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
MDAM techniques and Index Skip Scan patch
First at 2021-10-22 02:16:00 by Peter Geoghegan <pg at bowt.ie>
Latest at 2022-03-29 03:19:15 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v41-0001-Unique-expressions.patch) at 2022-03-22 20:00:08 from Dmitry Dolgov <9erthalion6 at gmail.com>
    Attachment (v41-0001-Unique-expressions.patch) at 2022-03-22 20:00:08 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Introduce-RelOptInfo-notnullattrs-attribute.patch) at 2022-01-13 15:27:08 from Floris Van Nee <florisvannee at Optiver.com> (Patch: Yes)
    Attachment (sales_query.sql) at 2021-10-23 19:30:47 from Floris Van Nee <florisvannee at Optiver.com> (Patch: No)
History
When Who What
2022-06-28 10:50:37 Alexandre Felipe (bob.tpro) Added bob.tpro as reviewer
2022-03-24 11:32:49 Jesper Pedersen (jpedersen) Closed in commitfest 2022-03 with status: Returned with feedback
2022-03-23 17:35:56 Justin Pryzby (justinpryzby) New status: Needs review
2022-03-22 18:33:11 Dmitry Dolgov (erthalion) Changed targetversion to 16
2022-03-22 01:33:45 Andres Freund (andresfreund) New status: Waiting on Author
2022-02-02 16:40:02 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-28 21:02:41 Justin Pryzby (justinpryzby) New status: Needs review
2022-01-13 10:36:18 Julien Rouhaud (rjuju) New status: Waiting on Author
2021-12-03 06:41:36 Michael Paquier (michael-kun) Closed in commitfest 2021-11 with status: Moved to next CF
2021-11-06 17:42:43 Dmitry Dolgov (erthalion) Attached mail thread CAH2-WzmUscvoxVkokHxP=uPTDjSi0tJkFpUPD-CeA35dvn-CMw@mail.gmail.com
2021-10-21 18:11:06 Peter Geoghegan (pgeoghegan) Added pgeoghegan as reviewer
2021-10-11 07:52:44 Chris Travers (einhverfr) Added einhverfr as reviewer
2021-10-05 14:29:55 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-03 02:33:08 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-07-28 07:10:22 Jet Zhang (thinkj) Added thinkj as reviewer
2021-07-03 15:31:23 Yuming Wang (yumwang) Added yumwang as reviewer
2021-04-08 15:46:38 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-03-15 18:22:53 Dmitry Dolgov (erthalion) New status: Needs review
2021-02-01 13:11:22 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2021-02-01 13:10:42 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2021-02-01 13:10:38 Masahiko Sawada (masahikosawada) New status: Needs review
2020-12-01 13:34:33 Anastasia Lubennikova (lubennikovaav) New status: Waiting on Author
2020-12-01 13:34:28 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 13:34:23 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2020-11-30 16:18:30 Heikki Linnakangas (heikki) New status: Waiting on Author
2020-10-01 04:28:08 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-03 09:12:55 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-06-11 08:02:50 Andy Fan (andyf) Added andyf as reviewer
2020-06-11 06:44:26 Dmitry Dolgov (erthalion) Attached mail thread 20200609102247.jdlatmfyeecg52fi@localhost
2020-04-14 15:33:51 Dilip Kumar (dilip.kumar) Added dilip.kumar as reviewer
2020-04-08 15:35:58 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:02:03 Jesper Pedersen (jpedersen) Closed in commitfest 2020-01 with status: Moved to next CF
2020-01-20 19:18:58 Tomas Vondra (fuzzycz) Attached mail thread 1e59d800b38141c5af2ad3a64cf9758e@opammb0562.comp.optiver.com
2019-11-29 06:34:59 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-04 22:03:15 Cristiano Duarte (cunha17) Added cunha17 as reviewer
2019-09-30 19:01:49 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-22 13:50:58 Dmitry Dolgov (erthalion) New status: Needs review
2019-09-05 19:43:50 Álvaro Herrera (alvherre) New status: Waiting on Author
2019-08-02 16:11:43 Jesper Pedersen (jpedersen) New status: Needs review
2019-08-01 10:34:13 Jesper Pedersen (jpedersen) New status: Waiting on Author
2019-08-01 10:33:40 Jesper Pedersen (jpedersen) Closed in commitfest 2019-07 with status: Moved to next CF
2019-08-01 10:33:35 Jesper Pedersen (jpedersen) New status: Needs review
2019-07-09 14:00:05 Jesper Pedersen (jpedersen) Changed gitlink to https://github.com/jesperpedersen/postgres/tree/indexskipscan
2019-07-04 18:46:28 James Coleman (jcole1989) Added jcole1989 as reviewer
2019-07-02 02:45:54 Thomas Munro (macdice) Added macdice as reviewer
2019-06-14 17:34:33 Jesper Pedersen (jpedersen) Changed targetversion to None
2019-06-14 17:34:33 Jesper Pedersen (jpedersen) Changed gitlink to
2019-06-14 17:26:32 Jesper Pedersen (jpedersen) New status: Waiting on Author
2019-04-06 20:41:42 David Steele (dsteele) Closed in commitfest 2019-03 with status: Moved to next CF
2019-03-28 16:39:41 Dmitry Dolgov (erthalion) Changed authors to Dmitry Dolgov (erthalion), Thomas Munro (macdice), Jesper Pedersen (jpedersen)
2019-03-28 16:36:22 Dmitry Dolgov (erthalion) New status: Needs review
2019-02-06 20:12:43 Dmitry Dolgov (erthalion) Changed targetversion to 13
2019-02-03 10:13:45 Dmitry Dolgov (erthalion) New status: Waiting on Author
2019-02-03 10:11:55 Dmitry Dolgov (erthalion) Closed in commitfest 2019-01 with status: Moved to next CF
2019-02-03 10:11:51 Dmitry Dolgov (erthalion) New status: Needs review
2019-02-01 19:25:31 Jesper Pedersen (jpedersen) New status: Waiting on Author
2018-11-30 23:33:33 Dmitry Dolgov (erthalion) Closed in commitfest 2018-11 with status: Moved to next CF
2018-10-09 13:42:24 Pavel Stehule (okbobcz) Posted comment with messageid <153909254478.1479.11809244127214809171.pgcf@coridan.postgresql.org>
2018-10-02 05:45:22 Michael Paquier (michael-kun) Closed in commitfest 2018-09 with status: Moved to next CF
2018-09-18 04:09:46 mithun cy (mithun.cy) Removed mithun.cy from reviewers
2018-08-17 18:05:11 mithun cy (mithun.cy) Added mithun.cy as reviewer
2018-08-01 11:00:54 Jesper Pedersen (jpedersen) Changed authors to Thomas Munro (macdice), Jesper Pedersen (jpedersen)
2018-08-01 10:59:27 Jesper Pedersen (jpedersen) Changed authors to Jesper Pedersen (jpedersen)
2018-08-01 10:59:27 Jesper Pedersen (jpedersen) Changed gitlink to https://github.com/jesperpedersen/postgres/tree/indexskipscan
2018-08-01 10:58:28 Jesper Pedersen (jpedersen) Attached mail thread 707b6f68-16fa-7aa7-96e5-eeb4865e6a30@redhat.com
2018-08-01 10:58:28 Jesper Pedersen (jpedersen) Created patch record
Edit