use foreign keys to improve join estimates

539

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Created

2016-02-25 02:07:29

Last modified

2016-04-08 01:53:26 (8 years, 10 months ago)

Latest email

2016-04-07 12:42:55 (8 years, 10 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