Query Performance

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

Query Performance

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