This version of the Pivotal Greenplum documentation is no longer actively maintained. Click here to view the most up-to-date version of the Greenplum 4.x documentation.

GPORCA Configuration Parameters

gp_enable_relsize_collection

optimizer

optimizer_analyze_root_partition

optimizer_array_expansion_threshold

optimizer_cte_inlining_bound

optimizer_control

optimizer_enable_associativity

optimizer_enable_master_only_queries

optimizer_force_multistage_agg

optimizer_force_three_stage_scalar_dqa

optimizer_join_arity_for_associativity_commutativity

optimizer_join_order

optimizer_join_order_threshold

optimizer_nestloop_factor

optimizer_parallel_union

optimizer_print_missing_stats

optimizer_print_optimization_stats

optimizer_sort_factor