Postgres Pro
Downloads
Home   >   mailing lists

Change work_mem for one user - Mailing list pgsql-general

From Wenjun Che
Subject Change work_mem for one user
Date
Msg-id CACYkyiQU_88L7fud=f4ZS=LDAOSUT+dwMraFy-VKuUoaN57QJQ@mail.gmail.com
Whole thread Raw
Responses Re: Change work_mem for one user
List pgsql-general
Tree view
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

Move Fast.  Break Nothing.
www.openfin.co | @openfintech

pgsql-general by date:

Previous
From: Paul Förster
Date:
Subject: Re: How to keep format of views source code as entered?
Next
From: Tom Lane
Date:
Subject: Re: Change work_mem for one user