| From: | Wenjun Che <wenjun(at)openfin(dot)co> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Change work_mem for one user |
| Date: | 2021-01-27 01:11:18 |
| Message-ID: | CACYkyiQU_88L7fud=f4ZS=LDAOSUT+dwMraFy-VKuUoaN57QJQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | OpenFin
wenjun(at)openfin(dot)co
*Move Fast. Break Nothing.*
www.openfin.co | @openfintech
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-01-27 02:05:09 | Re: Change work_mem for one user |
| Previous Message | Stacey Haysler | 2021-01-26 20:31:20 | Re: Code of Conduct plan,Re: Code of Conduct plan,Re: Code of Conduct plan,Re: Code of Conduct plan |