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 max_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)