Syntax Sub-Partition Template 358 Constructing a pg_partitions-Equivalent Query 358 About Partition Pruning 358 Partition Maintenance 360 Partition Maintenance with the Modern Syntax 360 Adding a Partition enable_hashjoin 1719 enable_indexscan 1719 enable_mergejoin 1719 enable_nestloop 1719 enable_partition_pruning 1719 enable_seqscan 1720 enable_sort 1720 enable_tidscan 1720 escape_string_warning 1720 explain_pretty_print gp_dynamic_partition_pruning 1728 gp_eager_two_phase_agg 1728 gp_enable_agg_distinct 1728 VMware Greenplum 7 Documentation VMware by Broadcom 102 gp_enable_agg_distinct_pruning 1729 gp_enable_direct_dispatch

gp_debug_linger 1574 gp_default_storage_options 1574 gp_dynamic_partition_pruning 1576 gp_enable_agg_distinct 1576 gp_enable_agg_distinct_pruning 1576 gp_enable_direct_dispatch 1577 gp_enable_exchange_default_partition gp_enable_gpperfmon 1578 gp_enable_groupext_distinct_gather 1578 gp_enable_groupext_distinct_pruning 1579 gp_enable_multiphase_agg 1579 gp_enable_predicate_propagation 1579 gp_enable_preunique 1579 only. Do not partition small tables. Use partitioning only if partition elimination (partition pruning) can be achieved based on the query criteria. Choose range partitioning over list partitioning

1586 gp_dispatch_keepalives_interval 1586 gp_dynamic_partition_pruning 1586 gp_enable_agg_distinct 1586 gp_enable_agg_distinct_pruning 1587 gp_enable_direct_dispatch 1587 gp_enable_exchange_default_partition gp_enable_gpperfmon 1588 gp_enable_groupext_distinct_gather 1589 gp_enable_groupext_distinct_pruning 1589 gp_enable_multiphase_agg 1589 gp_enable_predicate_propagation 1589 gp_enable_preunique 1590 only. Do not partition small tables. Use partitioning only if partition elimination (partition pruning) can be achieved based on the query criteria. Choose range partitioning over list partitioning

gp_default_storage_options 1508 gp_dynamic_partition_pruning 1510 VMware Greenplum v6.17 Documentation VMware, Inc. 108 gp_enable_agg_distinct 1510 gp_enable_agg_distinct_pruning 1511 gp_enable_direct_dispatch 1511 gp_enable_gpperfmon 1512 gp_enable_groupext_distinct_gather 1513 gp_enable_groupext_distinct_pruning 1513 gp_enable_multiphase_agg 1513 gp_enable_predicate_propagation 1513 gp_enable_preunique 1514 only. Do not partition small tables. Use partitioning only if partition elimination (partition pruning) can be achieved based on the query criteria. Choose range partitioning over list partitioning

1598 gp_dispatch_keepalives_interval 1598 gp_dynamic_partition_pruning 1598 gp_enable_agg_distinct 1599 gp_enable_agg_distinct_pruning 1599 gp_enable_direct_dispatch 1599 gp_enable_exchange_default_partition gp_enable_gpperfmon 1601 gp_enable_groupext_distinct_gather 1601 gp_enable_groupext_distinct_pruning 1601 gp_enable_multiphase_agg 1601 gp_enable_predicate_propagation 1602 gp_enable_preunique 1602 only. Do not partition small tables. Use partitioning only if partition elimination (partition pruning) can be achieved based on the query criteria. Choose range partitioning over list partitioning

gp_dispatch_keepalives_interval 1906 gp_dynamic_partition_pruning 1906 gp_eager_two_phase_agg 1906 gp_enable_agg_distinct 1906 gp_enable_agg_distinct_pruning 1907 gp_enable_direct_dispatch 1907 gp_enable_ gp_enable_gpperfmon 1908 gp_enable_groupext_distinct_gather 1908 gp_enable_groupext_distinct_pruning 1908 gp_enable_multiphase_agg 1908 gp_enable_predicate_propagation 1909 gp_enable_preunique 1909 14982 Resolves an issue where Greenplum Database returned the wrong results when dynamic partition pruning by the Postgres Planner did not consider the operator class of the partition key. 14887 Resolves

gp_dispatch_keepalives_interval 1871 gp_dynamic_partition_pruning 1872 gp_eager_two_phase_agg 1872 gp_enable_agg_distinct 1872 gp_enable_agg_distinct_pruning 1872 gp_enable_direct_dispatch 1872 gp_enable_ gp_enable_gpperfmon 1873 gp_enable_groupext_distinct_gather 1874 gp_enable_groupext_distinct_pruning 1874 gp_enable_multiphase_agg 1874 gp_enable_predicate_propagation 1874 gp_enable_preunique 1874 14982 Resolves an issue where Greenplum Database returned the wrong results when dynamic partition pruning by the Postgres Planner did not consider the operator class of the partition key. 14887 Resolves

Documentation VMware, Inc. 108 gp_dynamic_partition_pruning 1865 gp_eager_two_phase_agg 1866 gp_enable_agg_distinct 1866 gp_enable_agg_distinct_pruning 1866 gp_enable_direct_dispatch 1866 gp_enable_ gp_enable_gpperfmon 1867 gp_enable_groupext_distinct_gather 1868 gp_enable_groupext_distinct_pruning 1868 gp_enable_multiphase_agg 1868 gp_enable_predicate_propagation 1868 gp_enable_preunique 1868 155 Resolves an issue where Greenplum Database returned the wrong results when dynamic partition pruning by the Postgres Planner did not consider the operator class of the partition key. 14887 Resolves

1592 gp_dispatch_keepalives_interval 1592 gp_dynamic_partition_pruning 1593 gp_enable_agg_distinct 1593 gp_enable_agg_distinct_pruning 1593 gp_enable_direct_dispatch 1593 gp_enable_exchange_default_partition gp_enable_gpperfmon 1594 gp_enable_groupext_distinct_gather 1594 gp_enable_groupext_distinct_pruning 1594 gp_enable_multiphase_agg 1595 gp_enable_predicate_propagation 1595 gp_enable_preunique 1595 configuration parameter gp_log_dynamic_partition_pruning to on. This example SET command enables the parameter. SET gp_log_dynamic_partition_pruning = on; Parent topic: About GPORCA GPORCA Features

gp_dispatch_keepalives_interval 1811 gp_dynamic_partition_pruning 1811 gp_eager_two_phase_agg 1811 gp_enable_agg_distinct 1811 gp_enable_agg_distinct_pruning 1812 gp_enable_direct_dispatch 1812 gp_enable_ gp_enable_gpperfmon 1813 gp_enable_groupext_distinct_gather 1813 gp_enable_groupext_distinct_pruning 1813 gp_enable_multiphase_agg 1813 gp_enable_predicate_propagation 1814 gp_enable_preunique 1814 configuration parameter gp_log_dynamic_partition_pruning to on. This example SET command enables the parameter. SET gp_log_dynamic_partition_pruning = on; Parent topic: About GPORCA GPORCA Features