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