DWS can control memory at job level. This helps you more efficiently utilize memory resources than work_mem does.
The cluster has been installed and works properly.
You can set query_mem for a session to control memory available for jobs.
The database administrator can manage the logical memory of the database by taking the following steps:
set query_mem='500MB'; SET
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.