Fix performance issue in foreign-key-aware join estimation

Edit

ID 1984

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 (5 years, 4 months ago)

Latest email 2019-07-21 22:35:27 (5 years, 3 months 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 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/1984
git checkout commitfest/cf/1984

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