- 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 default.
- 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.