ALTER SESSION alter session set parameter=value; atlasdb=# alter session set work_mem='10MB'; SET atlasdb=# show work_mem ; work_mem ---------- 10MB (1 row)