On 7 June 2018 at 14:51, Amit Langote <langote_amit...@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
