xin zhang created HAWQ-708:
------------------------------
Summary: Consume latest GPORCA features up to version 1.630
Key: HAWQ-708
URL: https://issues.apache.org/jira/browse/HAWQ-708
Project: Apache HAWQ
Issue Type: Improvement
Components: Optimizer
Reporter: xin zhang
Assignee: Amr El-Helw
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
