Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WuO3i-0001z0-6l for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Jun 2014 15:33:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WuO3h-0001Qc-MS for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Jun 2014 15:33:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1WuO3f-0001O1-PY for pgsql-hackers@postgresql.org; Tue, 10 Jun 2014 15:33:55 +0000 Received: from mail.anarazel.de ([217.115.131.40]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WuO3Y-0004td-Lu for pgsql-hackers@postgresql.org; Tue, 10 Jun 2014 15:33:54 +0000 Received: from intern.anarazel.de (p5DDC5B67.dip0.t-ipconnect.de [93.220.91.103]) (Authenticated sender: andres@anarazel.de) by mail.anarazel.de (Postfix) with ESMTPSA id 3E03C4E8006; Tue, 10 Jun 2014 17:33:48 +0200 (CEST) Date: Tue, 10 Jun 2014 17:33:47 +0200 To: Tom Lane Cc: Gurjeet Singh , Peter Eisentraut , PGSQL Hackers Subject: Re: /proc/self/oom_adj is deprecated in newer Linux kernels Message-ID: <20140610153347.GM8406@alap3.anarazel.de> References: <29121.1316185073@sss.pgh.pa.us> <1316355543.12186.9.camel@vanquo.pezone.net> <15953.1316362868@sss.pgh.pa.us> <1316420754.14001.3.camel@fsopti579.F-Secure.com> <16241.1316441883@sss.pgh.pa.us> <20140610143202.GI8406@alap3.anarazel.de> <30402.1402412692@sss.pgh.pa.us> <20140610150933.GK8406@alap3.anarazel.de> <30709.1402413628@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <30709.1402413628@sss.pgh.pa.us> [1;5BFrom: Andres Freund From: andres@anarazel.de (Andres Freund) X-Pg-Spam-Score: -3.3 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2014-06-10 11:20:28 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2014-06-10 11:04:52 -0400, Tom Lane wrote: > >> But anyway, yeah, the point of this feature is that the OOM priority > >> of the postmaster, and *only* the postmaster, should be raised. Allowing > >> unprivileged people to break that is not attractive on any level. > > > A superuser could already write a function that echoes into /proc? > > Maybe I'm mistaken, but I thought once the fork_process code has reset our > process's setting to zero it's not possible to lower it again (without > privileges we'd not have). No, doesn't look that way. It's possible to reset it to the value set at process start. So unless we introduce double forks for every backend start it can be reset by ordinary processes. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers