Re: postgres work_mem - Mailing list pgsql-general

From Tom Lane
Subject Re: postgres work_mem
Date
Msg-id 21831.1274121261@sss.pgh.pa.us
Whole thread Raw
In response to postgres work_mem  (akp geek <akpgeek@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: postgres work_mem
Next
From: Devrim GÜNDÜZ
Date:
Subject: New PostgreSQL RPM sets are available for Fedora / RHEL / CentOS