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


If a query executor process consumes more than this configured amount, then the process will not be cached for use in subsequent queries after the process completes. Systems with lots of connections or idle processes may want to reduce this number to free more memory on the segments. Note that this is a local parameter and must be set for every segment.

Value Range Default Set Classifications
number of megabytes 500 local