akp geek <akpgeek@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