Re: disallow SET WORK_MEM - Mailing list pgsql-general

From Bruce Momjian
Subject Re: disallow SET WORK_MEM
Date
Msg-id 201112051913.pB5JDwZ06885@momjian.us
Whole thread Raw
In response to disallow SET WORK_MEM  (Andreas Kretschmer <akretschmer@spamfence.net>)
Responses Re: disallow SET WORK_MEM
List pgsql-general
Andreas Kretschmer wrote:
> Hi @list,
>
> is it possible to disallow "set work_mem to ..." for regular
> (non-superuser) users?
>
> Background: a shared database server with multiple users.

We have discussed it and might offer that ability some day, but
currently there is no way to do that.  There are so many ways to mess
things up with a bad query that we are unclear if restricting work_mem
is really helpful.


--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-general by date:

Previous
From: Rafael Ostertag
Date:
Subject: Installing different PostgreSQL versions in parallel
Next
From: Andy Colson
Date:
Subject: Re: High-Concurrency GiST in postgreSQL