Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem)
Date
Msg-id 14593.1517581614@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Re: Improve OR conditions on joined columns (commonstar schema problem)  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: [HACKERS] Re: Improve OR conditions on joined columns (commonstar schema problem)
Re: [HACKERS] Re: Improve OR conditions on joined columns (commonstar schema problem)
List pgsql-hackers
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> ISTM this patch got somewhat stuck as we're not quite sure the
> transformation is correct in all cases. Is my impression correct?

Yeah, that's the core issue.

> If yes, how to we convince ourselves? Would some sort of automated testing
> (generating data and queries) help? I'm willing to spend some cycles on
> that, if considered helpful.

I'm not sure if that would be enough to convince doubters.  On the other
hand, if it found problems, that would definitely be useful.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Aleksandr Parfenov
Date:
Subject: Re: Flexible configuration for full-text search
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] path toward faster partition pruning