max_statement_mem

max_statement_mem

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

session

reload

superuser