use foreign keys to improve join estimates

Edit
Title use foreign keys to improve join estimates
Topic Performance
Created 2016-02-25 02:07:29
Last modified 2016-04-08 01:53:26 (7 years, 11 months ago)
Latest email 2016-04-07 12:42:55 (7 years, 11 months ago)
Status
2016-03: Committed
Target version
Authors Tomas Vondra (fuzzycz)
Reviewers Simon Riggs (simon)Become reviewer
Committer Simon Riggs (simon)
Links
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-04-08 01:53:26 Simon Riggs (simon) Closed in commitfest 2016-03 with status: Committed
2016-04-08 01:53:18 Simon Riggs (simon) Added simon as committer
2016-03-14 19:44:05 Tomas Vondra (fuzzycz) New status: Needs review
2016-03-14 13:12:29 David Steele (dsteele) New status: Waiting on Author
2016-03-11 10:04:18 Simon Riggs (simon) Added simon as reviewer
2016-02-27 05:24:32 Tomas Vondra (fuzzycz) Changed authors to Tomas Vondra (fuzzycz)
2016-02-25 02:07:29 Tomas Vondra (fuzzycz) Attached mail thread 552335D9.3090707@2ndquadrant.com
2016-02-25 02:07:29 Tomas Vondra (fuzzycz) Created patch record
Edit