System Resource Consumption Configuration Parameters in Greenplum

Memory Consumption Parameters

These parameters control system memory usage. You can adjust gp_vmem_protect_limit to avoid running out of memory at the segment hosts during query processing.

1. gp_vmem_idle_resource_timeout

2. gp_vmem_protect_limit

3. gp_vmem_protect_segworker_cache_limit

4. max_appendonly_tables

5. max_prepared_transactions

6. max_stack_depth

7. shared_buffers

8. temp_buffers