Re: [GENERAL] disallow SET WORK_MEM
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 br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] disallow SET WORK_MEM
Bruce Momjian br...@momjian.us writes: Andreas Kretschmer wrote: is it possible to disallow set work_mem to ... for regular (non-superuser) 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. Preventing people from setting an appropriate work_mem might well create more denial-of-service problems than it prevents. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general