Remove self join on a unique column

Edit

Title

Topic

Performance

Created

2018-07-02 16:28:46

Last modified

2020-11-27 10:40:13 (14 hours, 45 minutes ago)

Latest email

2020-11-27 16:49:57 (8 hours, 35 minutes ago)

Status

2020-11: Needs review

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

2019-07: Moved to next CF

2019-03: Moved to next CF

2019-01: Moved to next CF

2018-11: Moved to next CF

2018-09: Moved to next CF

Target version

Authors

Alexander Kuzmenkov (akuzmenkov), Andrey Lepikhov (lepikhov), Konstantin Knizhnik (knizhnik)

Reviewers

David Rowley (davidrowley)Become reviewer

Committer

Links

Emails

Removing unneeded self joins: First at 2018-05-16 15:43:33 by Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru>
Latest at 2020-11-27 16:49:57 by Heikki Linnakangas <hlinnaka at iki.fi>
Latest attachment (v24-0001-Remove-self-joins.patch) at 2020-10-31 09:26:29 from "Andrey V. Lepikhov" <a.lepikhov at postgrespro.ru>
    Attachment (v24-0001-Remove-self-joins.patch) at 2020-10-31 09:26:29 from "Andrey V. Lepikhov" <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-Self-Joins-v.23.patch) at 2020-04-03 04:43:41 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: No)
    Attachment (0001-Remove-self-joins-v.22.patch) at 2020-01-28 04:10:07 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-self-joins-v21.patch) at 2019-11-05 18:20:28 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-self-joins-v20.patch) at 2019-09-30 08:29:44 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-self-joins-20.patch) at 2019-09-27 16:38:00 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-self-joins-v19.patch) at 2019-08-07 16:23:34 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-self-joins-v18.patch) at 2019-08-05 11:24:52 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-Self-Joins-v17.patch) at 2019-06-27 06:42:05 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-self-joins-v16.patch) at 2019-05-13 16:21:24 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (v15-0001-Remove-self-joins.patch) at 2019-03-25 15:13:24 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (v14-remove-unique-self-joins.patch) at 2019-03-25 04:07:33 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v13-0001-Remove-unique-self-joins.patch) at 2019-03-22 14:39:40 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (v12-0001-Remove-unique-self-joins.patch) at 2019-03-20 12:20:35 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (v11-0001-Remove-self-joins-on-a-unique-column.patch) at 2019-02-28 14:09:34 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-self-joins-v10.patch) at 2019-02-22 00:25:12 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-Remove-self-joins-v9.patch) at 2018-12-24 16:28:01 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (remove-self-join-v7.patch) at 2018-11-21 12:54:20 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (remove-self-join-v6.patch) at 2018-10-18 12:47:09 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (remove-self-joins-v5.patch) at 2018-10-08 14:52:21 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-unique-self-joins-v4.patch) at 2018-08-03 16:49:47 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Remove-unique-self-joins-v3.patch) at 2018-07-27 12:26:03 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (0002-Remove-unique-self-joins-v2.patch) at 2018-06-25 15:26:28 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (remove-self-join-v1.patch) at 2018-05-16 15:43:33 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)

History

When	Who	What
2020-11-27 10:40:13	Andrey Lepikhov (lepikhov)	New status: Needs review
2020-09-30 06:56:09	Michael Paquier (michael-kun)	New status: Waiting on Author
2020-09-30 06:56:01	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-30 06:55:59	Michael Paquier (michael-kun)	New status: Needs review
2020-09-23 04:23:50	David Rowley (davidrowley)	New status: Waiting on Author
2020-09-21 22:16:38	David Rowley (davidrowley)	Added davidrowley as reviewer
2020-08-03 08:46:10	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-08-02 21:13:15	David Rowley (davidrowley)	Removed davidrowley from reviewers
2020-04-08 15:29:51	David Steele (dsteele)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-04-03 04:44:12	Andrey Lepikhov (lepikhov)	New status: Needs review
2020-04-01 15:35:08	David Steele (dsteele)	New status: Waiting on Author
2020-02-01 12:50:07	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-30 02:18:39	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-05 18:21:48	Andrey Lepikhov (lepikhov)	Changed authors to Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrey Lepikhov (lepikhov)
2019-09-30 18:55:30	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-08-01 23:55:00	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-04-03 12:27:44	Alexander Kuzmenkov (akuzmenkov)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-04-03 12:27:33	Alexander Kuzmenkov (akuzmenkov)	New status: Needs review
2019-03-20 22:55:18	David Rowley (davidrowley)	Added davidrowley as reviewer
2019-03-17 11:09:20	David Rowley (davidrowley)	New status: Waiting on Author
2019-02-01 12:40:43	Alexander Kuzmenkov (akuzmenkov)	Closed in commitfest 2019-01 with status: Moved to next CF
2018-11-29 12:23:49	Alexander Kuzmenkov (akuzmenkov)	Closed in commitfest 2018-11 with status: Moved to next CF
2018-10-02 01:18:02	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Moved to next CF
2018-07-02 16:29:07	Alexander Kuzmenkov (akuzmenkov)	Changed authors to Alexander Kuzmenkov (akuzmenkov)
2018-07-02 16:28:47	Alexander Kuzmenkov (akuzmenkov)	Attached mail thread 64486b0b-0404-e39e-322d-0801154901f3@postgrespro.ru
2018-07-02 16:28:46	Alexander Kuzmenkov (akuzmenkov)	Created patch record

Edit