Search Postgresql Archives

Change work_mem for one user

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux