Re: Change work_mem for one user

2021-01-26 Thread Wenjun Che
Hello Tom Thank you very much for the quick response. I just realized the issue is caused by the tool, DataGrid, I am using. In DataGrid, when I close a tab, it does not actually disconnect from the database so it does not re-login when I open a new tab. Again. thank you for the help. On T

Re: Change work_mem for one user

2021-01-26 Thread Tom Lane
Wenjun Che writes: > We are running pg 10.10 on AWS RDS. I want to increase work_mem for one > user with following command: > ALTER ROLE test_user SET work_mem TO '50 MB'; > After I run the command and log in as test_user, "show work_mem" still > shows the default 4MB. Hmm, works for me: regr

Change work_mem for one user

2021-01-26 Thread Wenjun Che
Hello We are running pg 10.10 on AWS RDS. I want to increase work_mem for one user with following command: ALTER ROLE test_user SET work_mem TO '50 MB'; After I run the command and log in as test_user, "show work_mem" still shows the default 4MB. Thank you -- Wenjun Che VP of Engineering