Re: why partition pruning doesn't work?

On Thu, Jun 7, 2018 at 8:51 AM, David Rowley
<david(dot)rowley(at)2ndquadrant(dot)com> wrote:
> On 7 June 2018 at 14:51, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
>> Thanks David. This one looks good. I also like it that hasparamlessexprs
>> is no longer determined and set in the planner.
>
> Thanks for checking it.
>
>> I checked what happens with the cases that Ashutosh complained about
>> upthread and seems that the pruning works as expected.
>
> [...]
>
>> explain (costs off, analyze) select * from t1 x left join t1 y on x.a =
>> y.b + 100 where y.a = 5;
>
> Yeah, I added a test to partition_prune.sql that verifies a similar case.

Thanks for taking care of that.

--
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company