Convert join OR clauses into UNION queries

ID 1001

Title Convert join OR clauses into UNION queries

Topic Performance

Created 2017-02-14 20:17:15

Last modified 2018-10-02 01:11:27 (6 years, 1 month ago)

Latest email 2018-10-02 01:32:10 (6 years, 1 month ago)

Status

2018-09: Returned with feedback

2018-07: Moved to next CF

2018-03: Moved to next CF

2018-01: Moved to next CF

2017-11: Moved to next CF

2017-09: Moved to next CF

2017-03: Moved to next CF

Target version

Authors Tom Lane (tgl)

Reviewers Peter Geoghegan (pgeoghegan), Jim Nasby (decibel), Noah Misch (nmisch)Become reviewer

Committer

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

Emails

Improve OR conditions on joined columns.: First at 2017-02-08 22:07:40 by Jim Nasby <Jim.Nasby at BlueTreble.com>
Latest at 2018-10-02 01:32:10 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (mk-bench-union-or.pl) at 2018-09-04 01:59:10 from Noah Misch <noah at leadboat.com>
    Attachment (mk-bench-union-or.pl) at 2018-09-04 01:59:10 from Noah Misch <noah at leadboat.com> (Patch: No)
    Attachment (join-or-to-union-5.patch) at 2018-08-23 18:10:46 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (join-or-to-union-4.patch) at 2018-01-04 22:50:48 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (join-or-to-union-3.patch) at 2017-09-12 12:48:14 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (join-or-to-union-2.patch) at 2017-02-14 19:18:54 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (join-or-to-union-1.patch) at 2017-02-12 00:30:35 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (test.sql) at 2017-02-08 22:07:40 from Jim Nasby <Jim.Nasby at BlueTreble.com> (Patch: No)

History

When	Who	What
2018-10-02 01:11:27	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Returned with feedback
2018-09-04 02:00:24	Noah Misch (nmisch)	New status: Waiting on Author
2018-09-03 20:48:26	Noah Misch (nmisch)	Added nmisch as reviewer
2018-08-10 22:15:27	Andrew Dunstan (adunstan)	Closed in commitfest 2018-07 with status: Moved to next CF
2018-04-21 06:15:35	Andres Freund (andresfreund)	Changed reviewers to Peter Geoghegan (pgeoghegan), Jim Nasby (decibel)
2018-04-10 12:38:02	David Steele (dsteele)	Closed in commitfest 2018-03 with status: Moved to next CF
2018-02-07 15:42:07	David Steele (dsteele)	Closed in commitfest 2018-01 with status: Moved to next CF
2017-11-30 01:29:54	Michael Paquier (michael-kun)	Closed in commitfest 2017-11 with status: Moved to next CF
2017-10-02 10:07:50	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2017-09 with status: Moved to next CF
2017-09-12 16:34:45	Tom Lane (tgl)	New status: Needs review
2017-09-12 14:29:27	Aleksander Alekseev (a.alekseev)	New status: Waiting on Author
2017-04-03 18:52:21	Andres Freund (andresfreund)	Closed in commitfest 2017-03 with status: Moved to next CF
2017-03-21 23:44:57	Jim Nasby (decibel)	Added decibel as reviewer
2017-02-14 20:17:33	Tom Lane (tgl)	Changed authors to Tom Lane (tgl)
2017-02-14 20:17:15	Tom Lane (tgl)	Attached mail thread 7f70bd5a-5d16-e05c-f0b4-2fdfc8873489@BlueTreble.com
2017-02-14 20:17:15	Tom Lane (tgl)	Created patch record