improving join estimates using FK

Edit

ID 210

Title improving join estimates using FK

Topic Performance

Created 2015-04-07 01:45:13

Last modified 2016-01-31 12:39:37 (8 years, 9 months ago)

Latest email 2016-04-07 12:42:55 (8 years, 7 months ago)

Status

2016-01: Returned with feedback

2015-11: Moved to next CF

2015-09: Moved to next CF

2015-07: Moved to next CF

Target version

Authors Tomas Vondra (fuzzycz)

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

Emails

PATCH: use foreign keys to improve join estimates v1: First at 2015-04-07 01:41:45 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest at 2016-04-07 12:42:55 by Simon Riggs <simon at 2ndQuadrant.com>
Latest attachment (0002-use-fkeys-in-join-estimation.patch) at 2016-04-07 12:35:39 from Tomas Vondra <tomas.vondra at 2ndquadrant.com>
    Attachment (0002-use-fkeys-in-join-estimation.patch) at 2016-04-07 12:35:39 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-add-foreign-key-info-into-relcache.patch) at 2016-04-06 23:15:59 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (estimation-with-fkeys-v3.patch) at 2016-03-14 19:42:32 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (estimation-with-fkeys-v2_davidv4.patch) at 2015-09-30 01:12:11 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (estimation-with-fkeys-v2_davidv3.patch) at 2015-09-27 12:00:03 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (estimation-with-fkeys-v2_davidv2.patch) at 2015-09-25 01:39:05 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (fkjoin2.sql) at 2015-09-24 11:57:53 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (estimation-with-fkeys-v2_david_delta.patch) at 2015-09-24 05:41:28 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (divide_by_zero.sql) at 2015-09-23 05:11:35 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: No)
    Attachment (0001-estimation-with-fkeys-v2.patch) at 2015-08-20 01:49:46 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-estimation-with-fkeys-v1.patch) at 2015-04-07 01:41:45 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)

History

When	Who	What
2016-01-31 12:39:37	Álvaro Herrera (alvherre)	Closed in commitfest 2016-01 with status: Returned with feedback
2016-01-03 02:23:57	David Rowley (davidrowley)	Removed davidrowley from reviewers
2015-12-24 02:45:32	Michael Paquier (michael-kun)	Closed in commitfest 2015-11 with status: Moved to next CF
2015-10-30 23:37:57	Michael Paquier (michael-kun)	New status: Waiting on Author
2015-10-30 23:37:45	Michael Paquier (michael-kun)	Closed in commitfest 2015-09 with status: Moved to next CF
2015-09-23 05:13:39	David Rowley (davidrowley)	Deleted annotation "Review" from CAKJS1f_GJjHi9GpVJhHsqtxtvxmdMRG=AEyZih_1P2pBvCjSSw@mail.gmail.com
2015-09-23 05:13:30	David Rowley (davidrowley)	Added annotation "Review" to CAKJS1f_GJjHi9GpVJhHsqtxtvxmdMRG=AEyZih_1P2pBvCjSSw@mail.gmail.com
2015-09-23 05:12:38	David Rowley (davidrowley)	New status: Waiting on Author
2015-08-26 07:48:14	Michael Paquier (michael-kun)	Closed in commitfest 2015-07 with status: Moved to next CF
2015-08-23 03:41:40	Tomas Vondra (fuzzycz)	New status: Needs review
2015-07-02 09:59:13	David Rowley (davidrowley)	New status: Waiting on Author
2015-06-30 21:32:44	David Rowley (davidrowley)	Added davidrowley as reviewer
2015-04-07 01:45:34	Tomas Vondra (fuzzycz)	Changed authors to Tomas Vondra (fuzzycz)
2015-04-07 01:45:13	Tomas Vondra (fuzzycz)	Attached mail thread 552335D9.3090707@2ndquadrant.com
2015-04-07 01:45:13	Tomas Vondra (fuzzycz)	Created patch record

Edit