Updated on 2022-08-16 GMT+08:00

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.