Fix performance issue in foreign-key-aware join estimation

Title

Topic

Bug Fixes

Created

2019-02-05 09:41:41

Last modified

2019-07-21 05:44:31 (4 years, 9 months ago)

Latest email

2019-07-21 22:35:27 (4 years, 9 months ago)

Status

2019-07: Committed

2019-03: Moved to next CF

Target version

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