From: Andrew Dunstan <andrew@dunslane.net>
To: pgsql-hackers@postgresql.org
Subject: Re: Can't find thread on Linux memory overcommit
Date: Thu, 21 Aug 2003 13:42:30 -0400
Message-ID: <3F450486.50907@dunslane.net> (raw)
In-Reply-To: <200308211013.26737.josh@agliodbs.com>
References: <200308201102.37559.josh@agliodbs.com>
<200308210919.48463.josh@agliodbs.com>
<3F44F6A1.8090900@dunslane.net>
<200308211013.26737.josh@agliodbs.com>
(er, that's "Andrew" :-)
It depends how important your data is to you. A modest server probably
costs a few thousand dollars. How much does an expert to install a
custom kernel cost? Probably about the same.
I believe paranoid mode is supposed to prevent any overcommiting that
can't later be honoured when the process comes to map the memory, and
strict mode is supposed to do the same in most normal circumstances.
Maybe someone more expert in kernel hackery than I am can give a better
answer.
BTW, Alan Cox is going on sabbatical from RH very soon - so there will
be no more -ac patches. By the time he returns 2.6 should have been
released and bedded down, with any luck.
andrew
Josh Berkus wrote:
>Alan,
>
>
>
>>You need to be careful using Alan's patch. The reason RH stopped using
>>this part of it in their errata kernels is that it had conflicts with
>>other stuff, specifically the rmap stuff (he told me that himself in
>>email).
>>
>>
>
>Hmmm ... that leaves us without a workaround for this problem, then, yes?
>Because even parnoid-mode kernels you can discourage, but not prevent,
>overcommitting.
>
>
>
>>For mission critical apps I would advise running the postmaster on a
>>dedicated machine, with no X or other nasty stuff running.
>>
>>
>
>Unfortunately, this is frequently not an option ... PostgreSQL is often
>together on a server with Apache, a JVM, and other server software. As
>happened in the one case of possible (diagnosis pending) failure that we are
>looking into. Of course, it could be something else ....
>
>
>
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-docs@postgresql.org
Cc: andrew@dunslane.net, pgsql-hackers@postgresql.org
Subject: Re: Can't find thread on Linux memory overcommit
In-Reply-To: <3F450486.50907@dunslane.net>
* 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