improving join estimates using FK

Edit

Title

Topic

Performance

Created

2015-04-07 01:45:13

Last modified

2016-01-31 12:39:37 (8 years, 2 months ago)

Latest email

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

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