akp geek <akpg...@gmail.com> writes:
> I would like to know if there is a way to restrict
> individual users not to change the work_mem parameter for their session?
No.
> Reason I am asking is if there is 2GB RAM available, if one of the user want
> to set the work_mem to 2GB because query is running slow. it might cause a
> problem right?
If you're allowing people to issue SQL commands directly, they can
easily cause performance problems with or without touching work_mem.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
