On Thu, Jun 7, 2018 at 8:51 AM, David Rowley <david.row...@2ndquadrant.com> wrote: > 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.
Thanks for taking care of that. -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company