Re: Discussion on missing optimizations

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Adam Brusselback <adambrusselback(at)gmail(dot)com>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Discussion on missing optimizations
Date: 2017-10-08 16:18:04
Message-ID: 20171008161804.xmdc7vb22ei66sgz@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2017-10-08 11:28:09 -0400, Tom Lane wrote:
> Adam Brusselback <adambrusselback(at)gmail(dot)com> writes:
> > On another note:
> >> turning ORs into UNIONs
>
> > This is another one which would be incredibly useful for me. I've had
> > to do this manually for performance reasons far too often.
>
> Well, maybe you could sign up to help review the open patch for that then:
> https://commitfest.postgresql.org/15/1001/
>
> The reason that's not in v10 is we haven't been able to convince
> ourselves whether it's 100% correct.

Unfortunately it won't help in this specific case (no support for UNION,
just UNION ALL), but I thought it might be interesting to reference
https://medium.com/@uwdb/introducing-cosette-527898504bd6
here.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-10-08 16:24:50 Re: Discussion on missing optimizations
Previous Message Tom Lane 2017-10-08 15:28:09 Re: Discussion on missing optimizations