postgres work_mem

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