Re: Big trouble with memory !! - Mailing list pgsql-general

From Tom Lane
Subject Re: Big trouble with memory !!
Date
Msg-id 5905.1112819879@sss.pgh.pa.us
Whole thread Raw
In response to Re: Big trouble with memory !!  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Big trouble with memory !!
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> What I don't understand is the problem with overcommitting.

The problem with Linux overcommit is that when the kernel does run out
of memory, the process it chooses to kill isn't necessarily one that was
using an unreasonable amount of memory.  The earlier versions were quite
willing to kill "init" ;-) ... I think they hacked it to prevent that
disaster, but it's still entirely capable of deciding to take out the
(real) postmaster, your mail daemon, or other processes you'd prefer not
to lose.  As such, the feature is really too dangerous to enable on
machines being used for production purposes.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with Set Returning Functions (SRFs)
Next
From: Tom Lane
Date:
Subject: Re: lower function