Re: Help with planner optimize performance issue

2017-08-09 Thread JD Zheng
Yes, we are using the Volcano planner. Thanks TED and Julian. That’s very helpful suggestions! -JD > On Aug 8, 2017, at 9:24 PM, Ted Xu wrote: > > Hi JD, > > If you're using Volcano planner, it is common sense that applying rules > will expand search space. However, if you put your rules care

Re: Help with planner optimize performance issue

2017-08-09 Thread Julian Hyde
I agree with what Ted said. In this case, you could use HepPlanner to tidy up the tree - combining filters - before you go into the VolcanoPlanner phase. Real-world planners use tricks such as multi-phase optimization, because otherwise there are combinatorial traps. Julian > On Aug 8, 2017,

Re: Help with planner optimize performance issue

2017-08-08 Thread Ted Xu
Hi JD, If you're using Volcano planner, it is common sense that applying rules will expand search space. However, if you put your rules carefully, the space expansion is linear to rule apply and rels. According to your test result, it's better if you can check your rules to see if there is exponen

Help with planner optimize performance issue

2017-08-08 Thread JD Zheng
Hi, We use RelBuilder to build logical relational algebra trees for our domain specific language. It is possible that the user might construct a relational algebra tree with several “where” clause. In this case, the RelBuilder will build a relnode tree with multiple filters one followed by ano