Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgres work_mem

postgres work_mem

From
akp geek
Date:
dear all -

                I would like to know if there is a way to restrict individual users not to change the work_mem parameter for their session? 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?


Regards

Re: postgres work_mem

From
Tom Lane
Date:
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