use foreign keys to improve join estimates

Edit
ID 539
Title use foreign keys to improve join estimates
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2016-02-25 02:07:29
Last modified 2016-04-08 01:53:26 (9 years ago)
Latest email 2016-04-07 12:42:55 (9 years ago)
Status
2016-03 (2016-03-01 – 2016-03-31): 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