There are additional GPORCA features benefiting the HAWQ community, and this ticket is to bump the GPORCA from version 1.627 to 1.630. Here is list of new features in GPORCA:
– 1.628 and rename EatMalloc to EatTracker
Better memory tracking.
– 1.629 to include new GUC for Join Exploration
New GUC optimizer_join_arity_for_associativity_commutativity is added to
control Join exploration, hence speed up optimization time 116333899
For example, `set optimizer_join_arity_for_associativity_commutativity=x` will
hint at the optimizer to stop exploring join associativity and join
commutativity transformations when an n-ary join operator has more than
x children during optimization, pruning quite a bit of the search space.
– 1.630 to fix CTE Predicate pushdown
This fix will prevent predicate pushdown with volatile function like
random(), which caused wrong result if predicates were duplicated.