index-only scans with partial indexes

Edit

ID 299

Title index-only scans with partial indexes

Topic Performance

Created 2015-07-10 18:32:48

Last modified 2016-03-31 22:00:55 (8 years, 7 months ago)

Latest email 2016-04-01 02:39:49 (8 years, 7 months ago)

Status

2016-03: Committed

2016-01: Moved to next CF

2015-11: Moved to next CF

2015-09: Moved to next CF

Target version

Authors Kyotaro Horiguchi (horiguti), Tomas Vondra (fuzzycz)

Reviewers Kyotaro Horiguchi (horiguti), Kevin Grittner (kgrittn), Konstantin Knizhnik (knizhnik)Become reviewer

Committer Tom Lane (tgl)

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/299
git checkout commitfest/cf/299

Emails

PATCH: index-only scans with partial indexes: First at 2015-07-10 18:29:43 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest at 2016-04-01 02:39:49 by Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp>
Latest attachment (partial-index-only-scan-v11.patch) at 2016-03-31 12:53:58 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp>
    Attachment (partial-index-only-scan-v11.patch) at 2016-03-31 12:53:58 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partial-index-only-scan-v10.patch) at 2016-03-29 18:31:19 from Kevin Grittner <kgrittn at gmail.com> (Patch: Yes)
    Attachment (partial-index-only-scan-v9.patch) at 2016-03-20 16:00:08 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (partial-index-only-scan-v8.patch) at 2016-03-09 08:29:49 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partial-index-only-scan-v7.patch) at 2016-02-26 07:06:37 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partial-index-only-scan-v6.patch) at 2016-02-24 00:13:22 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Use-IndexOptInfo-to-store-index-rinfos.patch) at 2015-10-08 05:30:29 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partial-index-only-scan-v5-am1.patch) at 2015-10-06 06:12:02 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partial-index-only-scan-v5.patch) at 2015-09-30 23:36:51 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (partial-index-only-scan-v4.patch) at 2015-09-29 16:56:45 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (partial-index-only-scan-v3.patch) at 2015-09-26 16:00:33 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (partial-index-only-scan-v2.patch) at 2015-09-26 11:28:52 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (indexonly_cost_bug.patch) at 2015-09-14 10:09:01 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (table.sql) at 2015-09-04 21:03:31 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (partial-index-only-scan-v1.patch) at 2015-07-10 18:29:43 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)

History

When	Who	What
2016-03-31 22:00:55	Tom Lane (tgl)	Closed in commitfest 2016-03 with status: Committed
2016-03-30 23:36:16	Tom Lane (tgl)	Added tgl as committer
2016-03-29 18:32:10	Kevin Grittner (kgrittn)	New status: Ready for Committer
2016-03-29 18:31:45	Kevin Grittner (kgrittn)	Removed kgrittn from committers
2016-03-16 16:13:26	David Steele (dsteele)	New status: Needs review
2016-03-08 23:09:12	Tom Lane (tgl)	New status: Waiting on Author
2016-03-04 21:03:15	Kevin Grittner (kgrittn)	Added kgrittn as committer
2016-02-26 07:12:44	Kyotaro Horiguchi (horiguti)	New status: Ready for Committer
2016-02-26 07:11:06	Kyotaro Horiguchi (horiguti)	Changed authors to Kyotaro Horiguchi (horiguti), Tomas Vondra (fuzzycz)
2016-02-15 05:46:46	Kyotaro Horiguchi (horiguti)	Changed reviewers to Kyotaro Horiguchi (horiguti), Kevin Grittner (kgrittn), Konstantin Knizhnik (knizhnik)
2016-02-03 07:26:29	Konstantin Knizhnik (knizhnik)	Added knizhnik as reviewer
2016-01-31 12:35:38	Álvaro Herrera (alvherre)	Closed in commitfest 2016-01 with status: Moved to next CF
2015-12-24 07:35:16	Michael Paquier (michael-kun)	Closed in commitfest 2015-11 with status: Moved to next CF
2015-12-14 20:33:38	Tomas Vondra (fuzzycz)	New status: Needs review
2015-10-30 23:38:17	Michael Paquier (michael-kun)	New status: Waiting on Author
2015-10-30 23:38:05	Michael Paquier (michael-kun)	Closed in commitfest 2015-09 with status: Moved to next CF
2015-09-13 18:03:38	Kevin Grittner (kgrittn)	New status: Waiting on Author
2015-09-03 18:36:30	Kevin Grittner (kgrittn)	Added kgrittn as reviewer
2015-07-10 18:33:08	Tomas Vondra (fuzzycz)	Changed authors to Tomas Vondra (fuzzycz)
2015-07-10 18:32:48	Tomas Vondra (fuzzycz)	Attached mail thread 55A00F17.1020608@2ndquadrant.com
2015-07-10 18:32:48	Tomas Vondra (fuzzycz)	Created patch record

Edit