From: | Wenjun Che <wenjun(at)openfin(dot)co> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Change work_mem for one user |
Date: | 2021-01-27 02:16:56 |
Message-ID: | CACYkyiQz8PfEKwbfxd2-SsqRZQGg_feYJ8=a3bw_+DYeEsUY9g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 Tue, Jan 26, 2021 at 9:05 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
--
Wenjun Che
VP of Engineering | OpenFin
wenjun(at)openfin(dot)co
*Move Fast. Break Nothing.*
www.openfin.co | @openfintech
From | Date | Subject | |
---|---|---|---|
Next Message | Lisa Ruby | 2021-01-27 02:19:25 | Postgres 9.3 service no longer starts on Windows 8.1 |
Previous Message | Tom Lane | 2021-01-27 02:05:09 | Re: Change work_mem for one user |