Fix partitionwise join with partially-redundant join clauses

Edit

ID 2266

Title Fix partitionwise join with partially-redundant join clauses

Topic Server Features

Created 2019-08-30 03:06:45

Last modified 2024-07-30 07:25:03 (3 months, 3 weeks ago)

Latest email 2024-07-30 07:36:00 (3 months, 3 weeks ago)

Status

2024-07: Committed

2024-03: Moved to next CF

2022-07: Moved to next CF

2022-03: Moved to next CF

2022-01: Moved to next CF

2021-09: Moved to next CF

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

2020-01: Moved to next CF

2019-11: Moved to next CF

2019-09: Moved to next CF

Target version

Authors Richard Guo (richardguo)

Reviewers Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat)Become reviewer

Committer Richard Guo (richardguo)

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/2266
git checkout commitfest/cf/2266

Emails

A problem about partitionwise join: First at 2019-08-26 09:32:48 by Richard Guo <riguo at pivotal.io>
Latest at 2024-07-30 07:36:00 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v7-0001-Fix-partitionwise-join-with-partially-redundant-join-clauses.patch) at 2024-02-21 11:24:54 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v7-0001-Fix-partitionwise-join-with-partially-redundant-join-clauses.patch) at 2024-02-21 11:24:54 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Fix-up-partitionwise-join.patch) at 2022-04-25 07:21:06 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Fix-up-partitionwise-join.patch) at 2021-07-21 08:44:53 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Fix-up-partitionwise-join.patch) at 2020-11-10 09:12:58 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Fix-up-partitionwise-join.patch) at 2020-04-04 20:37:58 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Fix-up-partitionwise-join.patch) at 2020-01-19 04:01:16 from Richard Guo <riguo at pivotal.io> (Patch: Yes)
    Attachment (v1-0001-Fix-up-partitionwise-join.patch) at 2019-08-29 09:44:53 from Richard Guo <riguo at pivotal.io> (Patch: Yes)

History

When	Who	What
2024-07-30 07:25:03	Richard Guo (richardguo)	Closed in commitfest 2024-07 with status: Committed
2024-07-30 07:25:03	Richard Guo (richardguo)	Changed committer to richardguo
2024-04-09 06:21:47	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-03-04 09:58:07	Etsuro Fujita (efujita)	Removed efujita from reviewers
2024-02-21 11:30:51	Richard Guo (richardguo)	Changed name to Fix partitionwise join with partially-redundant join clauses
2024-02-21 11:29:51	Richard Guo (richardguo)	Closed in commitfest 2022-07 with status: Moved to next CF
2024-02-21 11:29:22	Richard Guo (richardguo)	New status: Needs review
2022-08-01 20:24:18	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Returned with feedback
2022-04-08 15:19:37	Greg Stark (stark)	Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:40:03	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2021-11-22 06:52:54	Richard Guo (richardguo)	Closed in commitfest 2021-09 with status: Moved to next CF
2021-11-22 06:52:04	Richard Guo (richardguo)	New status: Needs review
2021-10-05 17:19:45	Jaime Casanova (jcasanov)	Closed in commitfest 2021-09 with status: Returned with feedback
2021-08-03 02:33:02	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-04-08 15:46:56	David Steele (dsteele)	Closed in commitfest 2021-03 with status: Moved to next CF
2021-02-01 12:44:19	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 11:09:15	Anastasia Lubennikova (lubennikovaav)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-27 12:05:59	Ashutosh Bapat (ashutoshbapat)	Added ashutoshbapat as reviewer
2020-11-11 07:53:44	Richard Guo (richardguo)	New status: Needs review
2020-11-06 15:25:24	Anastasia Lubennikova (lubennikovaav)	Posted comment with messageid <160467632488.7362.12712548134124442813.pgcf@coridan.postgresql.org>
2020-11-06 15:25:24	Anastasia Lubennikova (lubennikovaav)	New status: Waiting on Author
2020-10-01 04:26:40	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-03 20:39:26	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 15:37:33	David Steele (dsteele)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-04-04 20:38:08	Tom Lane (tgl)	Added tgl as reviewer
2020-02-01 12:56:26	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-29 03:02:29	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-29 03:02:24	Michael Paquier (michael-kun)	Changed topic to Server Features
2019-09-30 18:33:20	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-20 04:49:35	Dilip Kumar (dilip.kumar)	Added dilip.kumar as reviewer
2019-08-30 05:58:17	Etsuro Fujita (efujita)	Added efujita as reviewer
2019-08-30 03:12:04	Richard Guo (richardguo)	Changed name to Fix up partitionwise join on how equi-join conditions between the partition keys are identified
2019-08-30 03:07:20	Richard Guo (richardguo)	Changed authors to Richard Guo (richardguo)
2019-08-30 03:06:45	Richard Guo (richardguo)	Attached mail thread CAN_9JTzo_2F5dKLqXVtDX5V6dwqB0Xk+ihstpKEt3a1LT6X78A@mail.gmail.com
2019-08-30 03:06:45	Richard Guo (richardguo)	Created patch record

Edit