Help Center/ GaussDB(DWS)/ More Documents/ Developer Guide (Kuala Lumpur Region)/ Resource Load Management/ Memory Management/ Job-Level Memory Control
Updated on 2022-08-16 GMT+08:00
View PDF
Share

Job-Level Memory Control

Context

GaussDB(DWS) can control memory at job level. This helps you more efficiently utilize memory resources than work_mem does.

Prerequisites

The cluster has been installed and works properly.

Memory Parameters

You can set query_mem for a session to control memory available for jobs.

Procedure

The database administrator can manage the logical memory of the database by taking the following steps:

  1. Set query_mem to 500MB. 

    1
2
    		 
    set query_mem='500MB';
SET

  2. Execute the job.

If query_mem exceeds the upper limit of memory available in the resource pool or is less than 256 MB, query_mem will not take effect. Available memory for jobs is still controlled by work_mem.

Parent topic: Memory Management