Re: PG Killed by OOM Condition - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: PG Killed by OOM Condition
Date
Msg-id 20051003212517.GB11950@surnet.cl
Whole thread Raw
In response to Re: PG Killed by OOM Condition  (Jeff Davis <jdavis-pgsql@empires.org>)
List pgsql-hackers
On Mon, Oct 03, 2005 at 01:25:00PM -0700, Jeff Davis wrote:
> Martijn van Oosterhout wrote:
> > On Mon, Oct 03, 2005 at 11:03:06PM +1000, John Hansen wrote:
> > 
> >>Might it be worth while protecting the postmaster from an OOM Kill on
> >>Linux by setting /proc/{pid}/oom_adj to -17 ?
> >>(Described vaguely in mm/oom_kill.c)
> > 
> > Has it actually happened to you? PostgreSQL is pretty good about its
> > memory usage. Besides, seems to me it should be an system admisitrator
> > descision.

Maybe what we could do is put a line to change the setting in the
contrib/start-script/linux script, and perhaps lobby the packagers of
Linux distributions to do the same.

ISTM it's trivial to test whether the file exists, and useful to
activate the feature if available.

-- 
Alvaro Herrera                                http://www.PlanetPostgreSQL.org
"In fact, the basic problem with Perl 5's subroutines is that they're not
crufty enough, so the cruft leaks out into user-defined code instead, by
the Conservation of Cruft Principle."  (Larry Wall, Apocalypse 6)


pgsql-hackers by date:

Previous
From: Ron Peacetree
Date:
Subject: Re: [PERFORM] A Better External Sort?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Tuning current tuplesort external sort code for 8.2