On 7 June 2018 at 14:51, Amit Langote <Langote_Amit_f8@lab.ntt.co.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.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services