Covering B-tree indexes (aka INCLUDE)

Edit
ID 1350
Title Covering B-tree indexes (aka INCLUDE)
Topic Server Features
Created 2017-10-31 08:26:15
Last modified 2018-04-07 20:42:28 (6 years, 8 months ago)
Latest email 2018-04-10 16:03:11 (6 years, 8 months ago)
Status
2018-03: Committed
2018-01: Moved to next CF
2017-11: Moved to next CF
Target version
Authors Anastasia Lubennikova (lubennikovaav)
Reviewers Peter Geoghegan (pgeoghegan), Alexander Korotkov (smagen), Andrey Borodin (x4m)Become reviewer
Committer Fedor Sigaev (sigaev)
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/1350
git checkout commitfest/cf/1350
Emails
WIP: Covering + unique indexes.
First at 2015-10-08 15:18:42 by Anastasia Lubennikova <a.lubennikova at postgrespro.ru>
Latest at 2018-04-10 16:03:11 by Teodor Sigaev <teodor at sigaev.ru>
Latest attachment (pg_constraint-2.patch) at 2018-04-09 14:21:48 from Alexander Korotkov <a.korotkov at postgrespro.ru>
    Attachment (pg_constraint-2.patch) at 2018-04-09 14:21:48 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (pg_constraint.patch) at 2018-04-09 14:07:00 from "Shinoda, Noriyoshi" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (0001-Remove-some-superfluous-amcheck-INCLUDE-tests.patch) at 2018-04-08 19:03:32 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (0001-Covering-v17.patch) at 2018-04-07 14:34:37 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)
    Attachment (0001-Covering-v16.patch) at 2018-04-07 12:48:06 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)
    Attachment (test_include2.pl) at 2018-04-07 11:57:38 from Erik Rijkers <er at xs4all.nl> (Patch: No)
    Attachment (0001-Covering-v15.patch) at 2018-04-06 18:08:37 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Covering-v14.patch) at 2018-04-06 15:49:28 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Covering-core-v13.patch) at 2018-04-05 14:59:17 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (create_index.sgml.covering_indexes.20180405.diff) at 2018-04-05 14:02:35 from Erik Rijkers <er at xs4all.nl> (Patch: Yes)
    Attachment (0001-Covering-core-v12.patch) at 2018-04-04 22:09:11 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Covering-core-v11.patch) at 2018-04-02 23:27:33 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Covering-core-v10.patch) at 2018-04-01 17:09:38 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Covering-core-v9.patch) at 2018-03-30 23:08:24 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Covering-core-v9.patch) at 2018-03-30 13:24:27 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Covering-core-v8.patch) at 2018-03-28 14:59:31 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Tests-of-covering-indexes-in-amcheck.patch) at 2018-03-28 13:27:13 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (0001-Covering-core-v7.patch) at 2018-03-08 16:13:50 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (0001-covering-core_v6.patch) at 2018-01-30 14:09:13 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (0001-covering-core_v5.patch) at 2018-01-25 14:01:46 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (0001-covering-core_v4.patch) at 2018-01-18 13:57:06 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (0001-covering-core_v4.patch) at 2018-01-16 16:50:23 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (amcheck_include.diff) at 2017-11-30 18:07:49 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (0001-covering-core_v3.patch) at 2017-10-31 08:21:30 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (0001-covering-core_v2.patch) at 2017-03-31 18:11:32 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (0001-covering-core_v1.patch) at 2017-03-31 17:40:59 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (0001-covering-core.patch) at 2017-03-30 15:26:05 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)
    Attachment (include_columns_10.0_v4.patch) at 2017-03-21 10:01:15 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (include_columns_10.0_v3.patch) at 2017-03-01 08:46:59 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (include_columns_10.0_v2.patch) at 2017-02-16 13:13:57 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (catalogs.sgml.diff) at 2017-01-10 03:08:18 from Erik Rijkers <er at xs4all.nl> (Patch: Yes)
    Attachment (include_columns_10.0_v1.patch) at 2017-01-09 15:02:54 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_9.7_v5.patch) at 2016-10-04 14:47:47 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_9.7_v4.patch) at 2016-10-03 12:29:38 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_9.7_v3.patch) at 2016-09-21 13:21:52 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_9.7_v2.patch) at 2016-09-14 14:58:50 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_9.7_v1.patch) at 2016-08-15 14:45:58 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_9.7_1.patch) at 2016-04-12 16:14:30 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_docs_update.patch) at 2016-04-08 15:05:04 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_10.1.patch) at 2016-04-08 12:45:49 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_10.0.patch) at 2016-04-07 16:01:42 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_9.1.patch) at 2016-04-06 14:49:09 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_9.0.patch) at 2016-04-06 13:15:42 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (test_including.sql) at 2016-04-05 14:56:54 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: No)
    Attachment (including_columns_8.0.patch) at 2016-03-28 13:45:28 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_7.0.patch) at 2016-03-21 16:53:49 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_6.0.patch) at 2016-03-14 13:57:46 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_5.0.patch) at 2016-03-01 17:10:20 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_4.0.patch) at 2016-02-11 16:46:24 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_3.0.patch) at 2016-01-26 14:35:31 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_2.0(rebased).patch) at 2016-01-22 15:19:33 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (including_columns_1.0.patch) at 2016-01-19 17:08:07 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (covering_unique_4.0.patch) at 2016-01-12 16:59:40 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (covering_unique_4.0.patch) at 2016-01-12 11:19:26 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (covering_unique_3.0.patch) at 2015-12-01 12:53:45 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (covering_unique_2.0.patch) at 2015-10-09 15:17:55 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (test.sql) at 2015-10-08 15:18:42 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: No)

Annotations

When Who Mail Annotation
2016-04-05 04:46:50 Peter Geoghegan (pgeoghegan) From Peter Geoghegan <pg@heroku.com>
at 2016-04-04 22:48:45
Review
2017-04-01 01:34:30 Peter Geoghegan (pgeoghegan) From Peter Geoghegan <pg@bowt.ie>
at 2017-03-31 23:31:24
Review
2017-11-27 09:46:10 Andrey Borodin (x4m) From Andrey Borodin <x4mmm@yandex-team.ru>
at 2017-11-12 11:40:46
Review
2018-01-17 08:46:28 Andrey Borodin (x4m) From Andrey Borodin <x4mmm@yandex-team.ru>
at 2018-01-17 08:45:49
Review
History
When Who What
2018-04-07 20:42:28 Fedor Sigaev (sigaev) Added sigaev as committer
2018-04-07 20:35:37 Andres Freund (andresfreund) Closed in commitfest 2018-03 with status: Committed
2018-04-07 20:35:37 Andres Freund (andresfreund) Changed committer to andresfreund
2018-04-07 02:11:57 Peter Geoghegan (pgeoghegan) New status: Ready for Committer
2018-04-07 02:11:53 Peter Geoghegan (pgeoghegan) Added pgeoghegan as reviewer
2018-03-26 13:42:14 David Steele (dsteele) New status: Waiting on Author
2018-03-23 10:08:48 Alexander Korotkov (smagen) Added smagen as reviewer
2018-02-06 21:58:07 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2018-01 with status: Moved to next CF
2018-01-25 14:02:08 Anastasia Lubennikova (lubennikovaav) New status: Ready for Committer
2018-01-21 14:45:44 Andrey Borodin (x4m) Posted comment with messageid <151654594496.23710.401435331419974842.pgcf@coridan.postgresql.org>
2018-01-21 14:45:44 Andrey Borodin (x4m) New status: Waiting on Author
2018-01-17 08:46:40 Andrey Borodin (x4m) New status: Ready for Committer
2018-01-17 08:46:28 Andrey Borodin (x4m) Added annotation "Review" to 0A48A43A-F1D4-4771-9E06-61A3581E1C50@yandex-team.ru
2018-01-16 16:52:25 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2018-01-09 05:13:01 Andrey Borodin (x4m) New status: Waiting on Author
2017-12-04 17:42:20 Andrey Borodin (x4m) New status: Ready for Committer
2017-11-30 05:57:18 Andrey Borodin (x4m) Closed in commitfest 2017-11 with status: Moved to next CF
2017-11-30 05:57:03 Andrey Borodin (x4m) New status: Needs review
2017-11-29 02:16:56 Michael Paquier (michael-kun) Closed in commitfest 2017-11 with status: Returned with feedback
2017-11-27 09:47:40 Andrey Borodin (x4m) New status: Waiting on Author
2017-11-27 09:46:10 Andrey Borodin (x4m) Added annotation "Review" to 7294DCE2-7368-4E28-BC29-2050E199A072@yandex-team.ru
2017-10-31 08:56:22 Andrey Borodin (x4m) Added x4m as reviewer
2017-10-31 08:27:07 Anastasia Lubennikova (lubennikovaav) Changed authors to Anastasia Lubennikova (lubennikovaav)
2017-10-31 08:26:15 Anastasia Lubennikova (lubennikovaav) Attached mail thread 56168952.4010101@postgrespro.ru
2017-10-31 08:26:15 Anastasia Lubennikova (lubennikovaav) Created patch record
Edit