From: Tom Lane <tgl@sss.pgh.pa.us>
To: Radovan Jablonovsky <radovan.jablonovsky@replicon.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL oom_adj postmaster process to -17
Date: Fri, 03 Aug 2012 14:32:52 -0400
Message-ID: <4273.1344018772@sss.pgh.pa.us> (raw)
In-Reply-To: <CAJYcdTu5VaLu8c+e+E1XALiHu=UHtBHcyGZqMVHforLVovG1aQ@mail.gmail.com>
References: <CAJYcdTvw-Xk9oi0Hzb9w3wZYfB6LJ5KMCQW0uR7o0HdFATC4tQ@mail.gmail.com>
<501925AD020000250004932E@gw.wicourts.gov>
<CAJYcdTu5VaLu8c+e+E1XALiHu=UHtBHcyGZqMVHforLVovG1aQ@mail.gmail.com>
Radovan Jablonovsky <radovan.jablonovsky@replicon.com> writes:
> In usual load there are not much pressure on memory, but it is possible to
> have all clients start using heavy reports. They are valid requests and
> could consume all memory. In this border and not likely but possible
> scenario it could be useful to let OOM killer to kill client's
> processes/connections but leave PostgreSQL system processes (postmaster,
> writer, stat, log, streaming, ...) excluded from reach of OOM killer.
The code already supports excluding the postmaster itself from OOM kills
while letting its children be subject to them. Being selective about
which children are subject is pointless, though: if any child is kill
-9'd, we have to zap the rest and restart, because there is no way to be
sure that the victim left shared memory in a consistent state.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, radovan.jablonovsky@replicon.com, Kevin.Grittner@wicourts.gov
Subject: Re: PostgreSQL oom_adj postmaster process to -17
In-Reply-To: <4273.1344018772@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox