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