Re: disallow SET WORK_MEM

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: disallow SET WORK_MEM
Date: 2011-12-05 19:13:58
Message-ID: 201112051913.pB5JDwZ06885@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2011-12-05 19:26:54 Re: High-Concurrency GiST in postgreSQL
Previous Message Rafael Ostertag 2011-12-05 18:43:07 Installing different PostgreSQL versions in parallel