Covering + unique indexes

Edit

ID 433

Title Covering + unique indexes

Topic Server Features

Created 2015-12-01 11:33:45

Last modified 2018-01-17 08:46:29 (6 years, 10 months ago)

Latest email 2018-04-10 16:03:11 (6 years, 7 months ago)

Status

2016-03: Returned with feedback

2016-01: Moved to next CF

Target version

Authors Anastasia Lubennikova (lubennikovaav)

Reviewers Peter Geoghegan (pgeoghegan), David Rowley (davidrowley)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/433
git checkout commitfest/cf/433

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