X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2C68ED1B8B7; Thu, 21 Aug 2003 14:09:18 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 81637-02; Thu, 21 Aug 2003 14:08:46 -0300 (ADT) Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by svr1.postgresql.org (Postfix) with ESMTP id 0A6FAD1B974; Thu, 21 Aug 2003 14:08:45 -0300 (ADT) Received: from dunslane.net (x.ncshp.org [199.90.235.43]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id h7LH1jP24413; Thu, 21 Aug 2003 12:01:46 -0500 Message-ID: <3F44FC9F.5060609@dunslane.net> Date: Thu, 21 Aug 2003 13:08:47 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030703 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-hackers@postgresql.org, pgsql-docs@postgresql.org Subject: Re: [HACKERS] Can't find thread on Linux memory overcommit References: <200308201102.37559.josh@agliodbs.com> <3F43BD9F.3050205@dunslane.net> <3F44C6DC.4060105@dunslane.net> <200308210919.48463.josh@agliodbs.com> In-Reply-To: <200308210919.48463.josh@agliodbs.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/68 X-Sequence-Number: 1928 I replied to Josh thus: ----------------------- 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). I am very wary of advising people to use what is essentially an experimental patch in a production system. This should be a last resort - a better solution is to have better control over what is running on your db server, so you can ensure it never gets into an OOM situation. For mission critical apps I would advise running the postmaster on a dedicated machine, with no X or other nasty stuff running. ------------------------- I do have a doc patch ready (with one sensible addition suggested by Jon Jensen). andrew Josh Berkus wrote: >Andrew, > > > >>I see btw that no change has been made to the docs. That's bad IMNSHO. >>The situation with RH is unchanged with today's kernel errata patch, >>too. I propose to submit a doc patch with the following wording, unless >>someone objects or improves it: >> >> > >First, off, I'm crossing this to PGSQL-DOCS, which is the correct list for doc >patches. > >Second, don't you think we should have some mention of the Alan Cox patch? > >Otherwise, I think your doc patch is good and needed before we go final. >When we settle the second question, I'll submit a diff for you. > > >