Covering B-tree indexes (aka INCLUDE)

Edit
ID 1350
Title Covering B-tree indexes (aka INCLUDE)
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Server Features
Tags
Created 2017-10-31 08:26:15
Last modified 2018-04-07 20:42:28 (7 years ago)
Latest email 2018-04-10 16:03:11 (7 years ago)
Status
2018-03 (2018-03-01 – 2018-03-31): Committed
2018-01 (2018-01-01 – 2018-01-31): Moved to different CF
2017-11 (2017-11-01 – 2017-11-30): Moved to different CF
Target version
Authors Anastasia Lubennikova (lubennikovaav)
Reviewers Peter Geoghegan (pgeoghegan), Alexander Korotkov (smagen), Andrey Borodin (x4m)Become reviewer
Committer Fedor Sigaev (sigaev)
Links
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