Erase the distinctClause if the result is unique by definition

Edit

Title

Topic

Performance

Created

2020-01-31 12:42:25

Last modified

2021-09-01 13:29:21 (2 weeks, 4 days ago)

Latest email

2021-08-30 08:59:17 (2 weeks, 6 days ago)

Status

2021-09: Needs review

2021-07: Moved to next CF

2021-03: Moved to next CF

2021-01: Moved to next CF

2020-11: Moved to next CF

2020-09: Moved to next CF

2020-07: Moved to next CF

2020-03: Moved to next CF

Target version

Authors

Andy Fan (andyf)

Reviewers

David Rowley (davidrowley), Ashutosh Bapat (ashutoshbapat), hou zhijie (houzj)Become reviewer

Committer

Links

Emails

[PATCH] Keeps tracking the uniqueness with UniqueKey: First at 2020-03-23 10:21:38 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest at 2021-02-11 02:05:07 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest attachment (v11-0002-Introduce-UniqueKey-attributes-on-RelOptInfo-str.patch) at 2020-09-08 23:51:12 from Andy Fan <zhihui.fan1213 at gmail.com>
    Attachment (v11-0002-Introduce-UniqueKey-attributes-on-RelOptInfo-str.patch) at 2020-09-08 23:51:12 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Introduce-UniqueKey-attributes-on-RelOptInfo-str.patch) at 2020-07-19 03:03:26 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v9-0005-Treat-the-input-as-sorted-if-the-group-by-clause-.patch) at 2020-06-29 09:59:21 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v8-0004-Remove-distinct-node-AggNode-if-the-input-is-uniq.patch) at 2020-05-13 11:59:08 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v7-0005-If-the-group-by-clause-is-unique-and-we-have-aggr.patch) at 2020-05-07 01:31:51 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Skip-DISTINCT-GROUP-BY-if-input-is-already-unique.patch) at 2020-04-16 02:17:00 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Introduce-UniqueKeys-to-determine-RelOptInfo-uniq.patch) at 2020-04-14 09:09:31 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Maintain-UniqueKey-at-each-RelOptInfo-this-inform.patch) at 2020-04-03 02:17:11 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: No)
    Attachment (v3-0001-Maintain-UniqueKey-at-each-RelOptInfo-this-inform.patch) at 2020-03-29 07:48:42 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Maintain-the-uniqueness-of-a-Query-from-bottom-to.patch) at 2020-03-26 01:55:35 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Maintain-the-uniqueness-of-a-Query-from-bottom-to.patch) at 2020-03-25 14:24:42 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Maintain-the-uniqueness-of-a-Query-from-bottom-to.patch) at 2020-03-23 10:21:38 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series): First at 2021-02-10 03:18:47 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest at 2021-08-30 08:59:17 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest attachment (v4-0005-Support-UniqueKey-on-JoinRel.patch) at 2021-08-18 12:29:33 from Andy Fan <zhihui.fan1213 at gmail.com>
    Attachment (v4-0005-Support-UniqueKey-on-JoinRel.patch) at 2021-08-18 12:29:33 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Just-refactor-pathkeys_useful_for_merging-split-a.patch) at 2021-08-15 14:33:13 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-design-uniquekey-v2.patch) at 2021-07-07 09:00:05 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-add-the-not-null-attrs-for-RelOptInfo.-Here-is-ho.patch) at 2021-07-03 14:08:26 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Introduce-notnullattrs-field-in-RelOptInfo-to-ind.patch) at 2021-02-18 12:58:13 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Introduce-notnullattrs-field-in-RelOptInfo-to-ind.patch) at 2021-02-16 14:03:46 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Introduce-notnullattrs-field-in-RelOptInfo-to-ind.patch) at 2021-02-10 03:27:25 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)

History

When	Who	What
2021-09-01 13:29:21	Andy Fan (andyf)	New status: Needs review
2021-09-01 13:29:01	Andy Fan (andyf)	Detached mail thread CAKU4AWrU35c9g3cE15JmVwh6B2Hzf4hf7cZUkRsiktv7AKR3Ag@mail.gmail.com
2021-08-03 02:43:35	Masahiko Sawada (masahikosawada)	New status: Waiting on Author
2021-08-03 02:42:34	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:42:31	Masahiko Sawada (masahikosawada)	New status: Needs review
2021-04-08 14:40:00	David Steele (dsteele)	New status: Waiting on Author
2021-04-08 14:39:45	David Steele (dsteele)	Closed in commitfest 2021-03 with status: Moved to next CF
2021-04-08 14:39:39	David Steele (dsteele)	New status: Needs review
2021-03-04 15:58:38	Dmitry Dolgov (erthalion)	Attached mail thread CAKU4AWrU35c9g3cE15JmVwh6B2Hzf4hf7cZUkRsiktv7AKR3Ag@mail.gmail.com
2021-03-04 15:57:52	Dmitry Dolgov (erthalion)	Attached mail thread CAKU4AWpQjAqJwQ2X-aR9g3+ZHRzU1k8hNP7A+_mLuOv-n5aVKA@mail.gmail.com
2021-02-01 13:12:56	Masahiko Sawada (masahikosawada)	New status: Waiting on Author
2021-02-01 13:12:43	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2021-02-01 13:12:37	Masahiko Sawada (masahikosawada)	New status: Needs review
2020-12-01 12:27:18	Anastasia Lubennikova (lubennikovaav)	New status: Waiting on Author
2020-12-01 12:27:14	Anastasia Lubennikova (lubennikovaav)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 12:27:09	Anastasia Lubennikova (lubennikovaav)	New status: Needs review
2020-11-30 16:23:13	Heikki Linnakangas (heikki)	New status: Waiting on Author
2020-10-12 02:38:17	hou zhijie (houzj)	Added houzj as reviewer
2020-10-01 04:29:37	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-10 14:04:35	Andy Fan (andyf)	New status: Needs review
2020-09-07 07:22:27	Michael Paquier (michael-kun)	New status: Waiting on Author
2020-08-03 09:13:22	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 16:08:24	David Steele (dsteele)	Changed targetversion to None
2020-04-08 15:31:38	David Steele (dsteele)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-04-03 05:51:04	Andy Fan (andyf)	New status: Needs review
2020-03-31 01:44:48	David Rowley (davidrowley)	New status: Waiting on Author
2020-03-26 01:52:16	Andy Fan (andyf)	Detached mail thread CAKU4AWqZvSyxroHkbpiHSCEAY2C41dG7VWs=c188KKznSK_2Zg@mail.gmail.com
2020-03-25 01:34:49	Andy Fan (andyf)	Changed targetversion to 13
2020-03-23 11:15:53	Andy Fan (andyf)	New status: Needs review
2020-03-23 11:15:33	Andy Fan (andyf)	Attached mail thread CAKU4AWrwZMAL=uaFUDMf4WGOVkEL3ONbatqju9nSXTUucpp_pw@mail.gmail.com
2020-03-10 14:01:43	Ashutosh Bapat (ashutoshbapat)	Added ashutoshbapat as reviewer
2020-03-10 02:31:57	David Rowley (davidrowley)	Added davidrowley as reviewer
2020-03-10 02:31:54	David Rowley (davidrowley)	New status: Waiting on Author
2020-02-07 10:15:15	Julien Rouhaud (rjuju)	Changed authors to Andy Fan (andyf)
2020-01-31 12:42:25	Andy Fan (andyf)	Attached mail thread CAKU4AWqZvSyxroHkbpiHSCEAY2C41dG7VWs=c188KKznSK_2Zg@mail.gmail.com
2020-01-31 12:42:25	Andy Fan (andyf)	Created patch record

Edit