A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. When gp_resqueue_memory_policy=auto, statement_mem and resource queue memory limits control query memory usage. Taking into account the configuration of a single segment host, calculate this setting as follows:
(seghost_physical_memory) / (average_number_concurrent_queries)
|Value Range||Default||Set Classifications|
|number of kilobytes||2000MB||master