Re: Setting oom_adj on linux? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Setting oom_adj on linux?
Date
Msg-id 20100104165515.GI3778@alvh.no-ip.org
Whole thread Raw
In response to Re: Setting oom_adj on linux?  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Setting oom_adj on linux?  (Magnus Hagander <magnus@hagander.net>)
Re: Setting oom_adj on linux?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Setting oom_adj on linux?  (Alex Hunsaker <badalex@gmail.com>)
List pgsql-hackers
Magnus Hagander wrote:

> Right. Which is why I like the idea of disabling the OOM killer for
> the *postmaster*, but not the regular backends. Gives it a chance to
> recover. It's not nice, but it's better than nothing.

It doesn't sound like the init script can reenable the killer for the
child processes though.  So, if there's anything that the core code
ought to do, is re-enable OOM-killer for postmaster children, after
being disabled by the initscript.

BTW, is it possible for pg_ctl to disable OOM-killer?  I guess not,
since it's not run by root ...


Is there a way to disable memory overcommit for particular processes?
That would be very useful -- just disable overcommit for all Postgres
processes, and there shouldn't be much need to enable the killer for
backends.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Setting oom_adj on linux?
Next
From: Simon Riggs
Date:
Subject: Re: New VACUUM FULL