Memory Consumption Parameters
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.
gp_vmem_idle_resource_timeout gp_vmem_protect_limit gp_vmem_protect_segworker_cache_limit gp_workfile_limit_files_per_query gp_workfile_limit_per_query gp_workfile_limit_per_segment max_appendonly_tables max_prepared_transactions |
max_stack_depth shared_buffers temp_buffers |