• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Resource Load Management
  5. Memory Management
  6. Job-level Memory Control

Job-level Memory Control

Context

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.

    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.