Covering + unique indexes

Edit
Title Covering + unique indexes
Topic Server Features
Created 2015-12-01 11:33:45
Last modified 2018-01-17 08:46:29 (10 months, 3 weeks ago)
Latest email 2018-04-10 16:03:11 (8 months ago)
Status
2016-03: Returned with feedback
2016-01: Moved to next CF
Authors Anastasia Lubennikova (lubennikovaav)
Reviewers Peter Geoghegan (pgeoghegan), David Rowley (davidrowley)Become reviewer
Committer Fedor Sigaev (sigaev)
Links
Emails
[PROPOSAL] Covering + unique indexes.
First at 2015-09-11 12:45:04 by Anastasia Lubennikova <a.lubennikova at postgrespro.ru>
Latest at 2016-03-16 01:51:56 by Peter Geoghegan <pg at heroku.com>
Latest attachment (btree-pageinspect-queries.sql) at 2016-03-16 01:51:56 from Peter Geoghegan <pg at heroku.com>
    Attachment (btree-pageinspect-queries.sql) at 2016-03-16 01:51:56 from Peter Geoghegan <pg at heroku.com> (Patch: No)

Annotations

When Who Mail Annotation
2016-03-15 04:21:40 Peter Geoghegan (pgeoghegan) From Peter Geoghegan <pg@heroku.com>
at 2016-03-15 03:43:04
Review
2016-03-16 01:54:25 Peter Geoghegan (pgeoghegan) From Peter Geoghegan <pg@heroku.com>
at 2016-03-16 01:51:56
Another review -- problems with leaf page ordering?
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-01 01:34:30 Peter Geoghegan (pgeoghegan) Added annotation "Review" to CAH2-WzkT-MeSnHozqoxmmNthVRK9O06rKjCyZZeUri0X41imvw@mail.gmail.com
2016-04-08 21:24:30 Tom Lane (tgl) Closed in commitfest 2016-03 with status: Returned with feedback
2016-04-08 16:46:38 Fedor Sigaev (sigaev) Closed in commitfest 2016-03 with status: Committed
2016-04-08 16:46:38 Fedor Sigaev (sigaev) Changed committer to sigaev
2016-04-06 13:18:18 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2016-04-05 04:46:50 Peter Geoghegan (pgeoghegan) Added annotation "Review" to CAM3SWZTfBosvae8Gh6AESRVKT3Fad7XcDkhZSbEqazZPE81rwQ@mail.gmail.com
2016-04-05 04:46:30 Peter Geoghegan (pgeoghegan) New status: Waiting on Author
2016-03-21 17:01:11 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2016-03-19 05:00:30 Peter Geoghegan (pgeoghegan) New status: Waiting on Author
2016-03-18 12:13:26 David Steele (dsteele) New status: Needs review
2016-03-16 01:54:25 Peter Geoghegan (pgeoghegan) Added annotation "Another review -- problems with leaf page ordering?" to CAM3SWZQmxk1HnV8KgcODoZyLVgfaVEpB84Ci1YyMBPNYux0Wmw@mail.gmail.com
2016-03-15 04:21:56 Peter Geoghegan (pgeoghegan) Deleted annotation "Review" from CAM3SWZTSu8OSTdRg4wEwmSd8okCMM-cbvuChqqn-niaUcY7GPg@mail.gmail.com
2016-03-15 04:21:40 Peter Geoghegan (pgeoghegan) Added annotation "Review" to CAM3SWZSsVV3GiLVyXCubRcy4_ErBf7RtGDbz-bYnyiP2tLQ_tg@mail.gmail.com
2016-03-15 03:50:41 Peter Geoghegan (pgeoghegan) Added annotation "Review" to CAM3SWZTSu8OSTdRg4wEwmSd8okCMM-cbvuChqqn-niaUcY7GPg@mail.gmail.com
2016-03-15 03:50:23 Peter Geoghegan (pgeoghegan) Attached mail thread 55F2CCD0.7040608@postgrespro.ru
2016-03-15 03:43:39 Peter Geoghegan (pgeoghegan) New status: Waiting on Author
2016-03-09 05:11:11 Peter Geoghegan (pgeoghegan) Added pgeoghegan as reviewer
2016-03-01 17:18:42 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2016-03-01 15:32:19 Anastasia Lubennikova (lubennikovaav) New status: Waiting on Author
2016-02-11 17:05:32 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2016-02-02 17:34:21 David Rowley (davidrowley) New status: Waiting on Author
2016-02-02 13:02:13 Álvaro Herrera (alvherre) Closed in commitfest 2016-01 with status: Moved to next CF
2016-01-31 08:05:20 David Rowley (davidrowley) New status: Waiting on Author
2016-01-20 15:04:02 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2016-01-05 22:56:20 David Rowley (davidrowley) New status: Waiting on Author
2015-12-24 00:15:56 David Rowley (davidrowley) Added davidrowley as reviewer
2015-12-01 11:34:11 Anastasia Lubennikova (lubennikovaav) Changed authors to Anastasia Lubennikova (lubennikovaav)
2015-12-01 11:33:45 Anastasia Lubennikova (lubennikovaav) Attached mail thread 56168952.4010101@postgrespro.ru
2015-12-01 11:33:45 Anastasia Lubennikova (lubennikovaav) Created patch record
Edit