Help Center> Data Warehouse Service> Developer Guide> Resource Load Management> Memory Management> Job-level Memory Control
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:
- Set query_mem to 500MB.
1 2
set query_mem='500MB'; SET
- 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
Last Article: Memory Management Overview
Next Article: Resource Load Management Framework Overview
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.