From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Wenjun Che <wenjun(at)openfin(dot)co> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Change work_mem for one user |
Date: | 2021-01-27 02:05:09 |
Message-ID: | 2349840.1611713109@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Wenjun Che <wenjun(at)openfin(dot)co> 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:
regression=# create user test_user;
CREATE ROLE
regression=# ALTER ROLE test_user SET work_mem TO '50 MB';
ALTER ROLE
regression=# show work_mem;
work_mem
----------
4MB
(1 row)
regression=# \c - test_user
You are now connected to database "regression" as user "test_user".
regression=> show work_mem;
work_mem
----------
50MB
(1 row)
Perhaps you also have a setting at the per-database level, or
per-user-and-database level? The latter would definitely override
a per-user setting; I don't recall offhand whether per-database
overrides per-user. Look into pg_db_role_setting to see what
there is.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Wenjun Che | 2021-01-27 02:16:56 | Re: Change work_mem for one user |
Previous Message | Wenjun Che | 2021-01-27 01:11:18 | Change work_mem for one user |