Re: Re: Improve OR conditions on joined columns (common star schema problem)

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Jim Nasby <jim(dot)nasby(at)openscg(dot)com>
Cc:	Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Re: Improve OR conditions on joined columns (common star schema problem)
Date:	2017-09-12 12:48:14
Message-ID:	12648.1505220494@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2017-02-08 22:07:40 from Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> 📎  2017-02-08 23:54:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2017-02-10 00:50:02 from Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>    2017-02-10 06:18:27 from Claudio Freire <klaussfreire(at)gmail(dot)com>    2017-02-12 00:30:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎     2017-02-12 11:51:26 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>      2017-02-12 17:32:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2017-02-12 23:06:31 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>        2017-02-13 01:15:35 from Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>     2017-02-14 19:18:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎      2017-02-14 20:47:37 from Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>       2017-02-14 21:03:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2017-03-16 16:54:37 from David Steele <david(at)pgmasters(dot)net>         2017-03-19 00:29:34 from Jim Nasby <jim(dot)nasby(at)openscg(dot)com>          2017-03-19 19:32:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2017-03-19 19:54:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2017-03-20 02:54:53 from Jim Nasby <jim(dot)nasby(at)openscg(dot)com>            2017-09-12 12:48:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎             2017-11-30 01:29:39 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>             2018-01-04 22:50:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎              2018-02-02 12:41:37 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>               2018-02-02 14:26:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2018-02-03 00:50:35 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                 2018-02-03 00:53:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2018-02-24 21:00:32 from Peter Geoghegan <pg(at)bowt(dot)ie>                2018-04-01 14:51:22 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>              2018-03-30 02:05:27 from Andres Freund <andres(at)anarazel(dot)de>               2018-04-01 14:54:34 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>              2018-08-23 18:10:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎               2018-08-24 00:20:31 from Peter Geoghegan <pg(at)bowt(dot)ie>                2018-08-24 01:27:54 from Peter Geoghegan <pg(at)bowt(dot)ie>               2018-09-04 01:59:10 from Noah Misch <noah(at)leadboat(dot)com> 📎                2018-10-02 01:11:18 from Michael Paquier <michael(at)paquier(dot)xyz>                 2018-10-02 01:32:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2018-10-02 14:39:41 from Noah Misch <noah(at)leadboat(dot)com>                   2018-10-02 14:53:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2019-03-18 00:09:42 from Noah Misch <noah(at)leadboat(dot)com>                     2021-05-16 02:03:07 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>      2017-04-03 18:44:20 from Andres Freund <andres(at)anarazel(dot)de>       2017-04-03 18:49:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
join-or-to-union-3.patch	text/x-diff	29.8 KB

In response to

• Re: Re: Improve OR conditions on joined columns (common star schema problem) at 2017-03-20 02:54:53 from Jim Nasby

Responses

• Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) at 2017-11-30 01:29:39 from Michael Paquier
• Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) at 2018-01-04 22:50:48 from Tom Lane

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Jeevan Chalke	2017-09-12 12:51:13	Re: Partition-wise aggregation/grouping
Previous Message	Michael Paquier	2017-09-12 12:34:43	Re: Coverage improvements of src/bin/pg_basebackup and pg_receivewal --endpos