Indexes with Included Columns (was Covering + unique indexes)

Edit
ID 961
Title Indexes with Included Columns (was Covering + unique indexes)
Topic Server Features
Created 2017-01-13 13:40:20
Last modified 2018-01-17 08:46:28 (6 years, 11 months ago)
Latest email 2018-04-10 16:03:11 (6 years, 8 months ago)
Status
2017-03: Returned with feedback
Target version
Authors Anastasia Lubennikova (lubennikovaav)
Reviewers Stephen Frost (sfrost), Andrew Dunstan (adunstan), Aleksander Alekseev (a.alekseev), Peter Geoghegan (pgeoghegan)Become reviewer
Committer
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/961
git checkout commitfest/cf/961
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-01-17 08:46:28 Andrey Borodin (x4m) Added annotation "Review" to 0A48A43A-F1D4-4771-9E06-61A3581E1C50@yandex-team.ru
2017-11-27 09:46:10 Andrey Borodin (x4m) Added annotation "Review" to 7294DCE2-7368-4E28-BC29-2050E199A072@yandex-team.ru
2017-04-08 14:02:34 David Steele (dsteele) Closed in commitfest 2017-03 with status: Returned with feedback
2017-04-01 01:34:58 Peter Geoghegan (pgeoghegan) Added pgeoghegan as reviewer
2017-04-01 01:34:42 Peter Geoghegan (pgeoghegan) New status: Waiting on Author
2017-04-01 01:34:30 Peter Geoghegan (pgeoghegan) Added annotation "Review" to CAH2-WzkT-MeSnHozqoxmmNthVRK9O06rKjCyZZeUri0X41imvw@mail.gmail.com
2017-03-24 12:47:42 Aleksander Alekseev (a.alekseev) Added a.alekseev as reviewer
2017-03-24 12:47:09 Aleksander Alekseev (a.alekseev) Posted review with messageid <20170324124709.22419.51178.pgcf@coridan.postgresql.org>
2017-03-24 12:47:09 Aleksander Alekseev (a.alekseev) New status: Ready for Committer
2017-02-16 16:07:17 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2017-02-14 12:47:01 Amit Kapila (amitkapila) New status: Waiting on Author
2017-02-02 15:14:19 Stephen Frost (sfrost) Changed reviewers to Stephen Frost (sfrost), Andrew Dunstan (adunstan)
2017-02-02 15:14:07 Stephen Frost (sfrost) Added sfrost as reviewer
2017-01-13 13:40:31 Anastasia Lubennikova (lubennikovaav) Changed authors to Anastasia Lubennikova (lubennikovaav)
2017-01-13 13:40:21 Anastasia Lubennikova (lubennikovaav) Attached mail thread 56168952.4010101@postgrespro.ru
2017-01-13 13:40:20 Anastasia Lubennikova (lubennikovaav) Created patch record
Edit