akp geek <akpgeek@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
