This article is half-done without your Comment! *** Please share your thoughts via Comment ***
General parameters:
max_resource_queues: Set the maximum number of resource queues
resource_select_only: Set ON = allow SELECT, SELECT INTO, CREATE TABLE AS SELECT, and DECLARE CURSOR, Set OFF = ALL SELECT + INSERT, UPDATE, and DELETE
max_resource_portals_per_transaction: Set the maximum number of simultaneously open cursors which will allow per transaction
stats_queue_level: Enables statistics collection on usage of resource queues
gp_resqueue_priority: This is enable by default
gp_resqueue_priority_sweeper_interval: Set the interval for recalculation of CPU Usage
gp_resqueue_priority_cpucores_per_segment: Very important, you can set number of CPU cores per segment
Parameters for Memory Utilization:
statement_mem: Runtime allocation of memory to a particular query
max_statement_mem: Only super user can set this to prevent the over-allocation of statement_mem
gp_resqueue_memory_policy: It enables Greenplum memory management feature. NONE = Memory management same as Greenplum Engine, AUTO = Controls by statement_mem
gp_vmem_protect_limit: Set the limit so that queries cannot exceed the usage of physical memory of segment host
Leave a Reply