Re: Improve OR conditions on joined columns (common starschema problem) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Improve OR conditions on joined columns (common starschema problem)
Date
Msg-id 20170403184420.ea3knbbap5acttnv@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] Improve OR conditions on joined columns (common star schema problem)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Improve OR conditions on joined columns (common star schema problem)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

On 2017-02-14 14:18:54 -0500, Tom Lane wrote:
> I think this might be code-complete, modulo the question of whether we
> want an enabling GUC for it.  I'm still concerned about the question
> of whether it adds more planning time than it's worth for most users.
> (Obviously it needs some regression test cases too, and a lot more
> real-world testing than I've given it.)

> One point that could use further review is whether the de-duplication
> algorithm is actually correct.  I'm only about 95% convinced by the
> argument I wrote in planunionor.c's header comment.
> 
> Potential future work includes finding join ORs in upper-level INNER JOIN
> ON clauses, and improving matters so we can do the unique-ification with
> hashing as well as sorting.  I don't think either of those things has to
> be in the first commit, though.

Are you planning to push this into v10? Given the looming freeze I'm
inclined to bump this to the next CF.

- Andres



pgsql-hackers by date:

Previous
From: "Sven R. Kunze"
Date:
Subject: Re: [PATCH] few fts functions for jsonb
Next
From: Tom Lane
Date:
Subject: Re: Improve OR conditions on joined columns (common star schema problem)