Greenplum Database dynamically eliminates irrelevant partitions
in a table and optimally allocates memory for different operators in a query.
These enhancements scan less data for a query, accelerate query processing, and
support more concurrency.
- Dynamic Partition Elimination
In Greenplum Database, values
available only when a query runs are used to dynamically prune partitions, which improves
query processing speed. Enable or disable dynamic partition elimination by setting the
server configuration parameter gp_dynamic_partition_pruning to
ON or OFF; it is ON by
- Memory Optimizations
Greenplum Database allocates memory
optimally for different operators in a query and frees and re-allocates memory during the
stages of processing a query.
Note: Greenplum Database
supports the Pivotal Query Optimizer. The Pivotal Query
Optimizer extends the planning and optimization capabilities of the Greenplum Database
legacy optimizer. For information about the features and limitations
of the Pivotal Query Optimizer, see Overview of the Pivotal Query Optimizer