use foreign keys to improve join estimates

539

Title

Topic

Performance

Created

2016-02-25 02:07:29

Last modified

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

Latest email

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

Status

2016-03: Committed

Target version

Authors

Tomas Vondra (fuzzycz)

Reviewers

Simon Riggs (simon)Become reviewer

Committer

Simon Riggs (simon)

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

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