Fix performance issue in foreign-key-aware join estimation

Edit
Title Fix performance issue in foreign-key-aware join estimation
Topic Bug Fixes
Created 2019-02-05 09:41:41
Last modified 2019-07-21 05:44:31 (1 month ago)
Latest email 2019-07-21 22:35:27 (1 month ago)
Status
2019-07: Committed
2019-03: Moved to next CF
Target version 13
Authors David Rowley (davidrowley)
Reviewers Tom Lane (tgl)Become reviewer
Committer David Rowley (davidrowley)
Links
Emails
Performance issue in foreign-key-aware join estimation
First at 2018-12-20 17:44:17 by Tom Lane <tgl at sss.pgh.pa.us>
Latest at 2019-07-21 22:35:27 by David Rowley <david.rowley at 2ndquadrant.com>
Latest attachment (0001-Speed-up-finding-EquivalenceClasses-for-a-given-set-.patch) at 2019-07-18 07:24:05 from David Rowley <david.rowley at 2ndquadrant.com>
    Attachment (0001-Speed-up-finding-EquivalenceClasses-for-a-given-set-.patch) at 2019-07-18 07:24:05 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (eclass_indexes_v7.patch) at 2019-06-16 07:42:14 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (eclass_indexes_v6.patch) at 2019-05-25 04:37:54 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (eclass_indexes_v5.patch) at 2019-03-21 21:10:06 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (eclass_indexes_v4.patch) at 2019-03-18 04:20:32 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (eclass_indexes_v3.patch) at 2019-03-10 11:08:45 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (eclass_indexes_v2.patch) at 2019-03-10 08:34:51 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (poc_eclass_indexing_v4.patch) at 2019-02-21 02:00:33 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (speed_up_matching_fkeys_to_eclasses.patch) at 2019-02-05 09:47:24 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (poc_eclass_indexing_v3.patch) at 2018-12-25 02:48:30 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (regression.diffs) at 2018-12-25 00:46:51 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (poc_eclass_indexing_v2.patch) at 2018-12-24 12:07:15 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (poc_eclass_indexing_v1.patch) at 2018-12-23 20:38:54 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (speed_up_matching_fkeys_to_eclasses.patch) at 2018-12-21 20:28:53 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (schema.sql) at 2018-12-20 17:44:17 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
History
When Who What
2019-07-21 05:44:31 David Rowley (davidrowley) Closed in commitfest 2019-07 with status: Committed
2019-07-21 05:44:31 David Rowley (davidrowley) Changed committer to davidrowley
2019-04-06 03:08:53 David Rowley (davidrowley) Closed in commitfest 2019-03 with status: Moved to next CF
2019-03-10 09:18:41 David Rowley (davidrowley) New status: Needs review
2019-03-09 00:10:03 David Rowley (davidrowley) Changed targetversion to 13
2019-03-08 19:13:50 Tom Lane (tgl) Added tgl as reviewer
2019-03-08 19:13:47 Tom Lane (tgl) New status: Waiting on Author
2019-03-03 22:08:06 Tom Lane (tgl) Removed tgl from reviewers
2019-02-20 21:28:36 Tom Lane (tgl) Added tgl as reviewer
2019-02-05 09:41:51 David Rowley (davidrowley) Changed authors to David Rowley (davidrowley)
2019-02-05 09:41:41 David Rowley (davidrowley) Attached mail thread 6970.1545327857@sss.pgh.pa.us
2019-02-05 09:41:41 David Rowley (davidrowley) Created patch record
Edit