Change work_mem for one user

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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