improving join estimates using FK

Edit
ID 210
Title improving join estimates using FK
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2015-04-07 01:45:13
Last modified 2016-01-31 12:39:37 (9 years ago)
Latest email 2016-04-07 12:42:55 (9 years ago)
Status
2016-01 (2016-01-02 – 2016-02-08): Returned with feedback
2015-11 (2015-11-01 – 2015-11-30): Moved to different CF
2015-09 (2015-09-01 – 2015-09-30): Moved to different CF
2015-07 (2015-07-01 – 2015-07-31): Moved to different CF
Target version
Authors Tomas Vondra (fuzzycz)
Reviewers Become reviewer
Committer
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-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