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

Parent topic: System Resource Consumption Parameters