[HAWQ-708] Consume latest GPORCA features up to version 1.630

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Optimizer
• Assignee: Amr El-Helw
• Reporter: xin zhang
• Created: 26/Apr/16 21:46
• Updated: 14/Jul/16 18:23
• Resolved: 14/Jul/16 18:23

Description

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.