Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 84A539F9F47 for ; Sun, 19 Nov 2006 16:42:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 21867-03 for ; Sun, 19 Nov 2006 16:42:47 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31807.mail.mud.yahoo.com (web31807.mail.mud.yahoo.com [68.142.207.70]) by postgresql.org (Postfix) with SMTP id 3D8EE9F98FA for ; Sun, 19 Nov 2006 16:42:46 -0400 (AST) Received: (qmail 25033 invoked by uid 60001); 19 Nov 2006 20:42:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=GLEE+H5T324a91FoVTxXq82FAsHAlkQJ+XEn3/3QT3vg3Usy8xjwMOlLvO/SyjuIS6niu2KzRi99mGiifvhdu7O7Y9l7BWYEUKDMcJpTPurboMte5nFunAGZjjCOC4vAjXOgAvIsShu3uZezBUpRVM50BYKZ5rROzS+4lMCHBc0= ; X-YMail-OSG: b34PfjUVM1neKUiLJsnUWceiD3OLJ8FML2SjnPzNpOIDJlUSMvrnAd3z1..SSEh9gDZoZEZueaxeIkM7bmZmSezZ7kXRh2ZffG1JdQMdFBfMUJgh6hQo66q89Y9dqYNp4YKqTjCrVLs- Received: from [24.54.196.198] by web31807.mail.mud.yahoo.com via HTTP; Sun, 19 Nov 2006 12:42:45 PST Date: Sun, 19 Nov 2006 12:42:45 -0800 (PST) From: Richard Broersma Jr Subject: Re: Postgres server crash To: Michael Stone , pgsql-performance@postgresql.org In-Reply-To: <20061119184105.GC2366@mathom.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <705637.23929.qm@web31807.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.231 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200611/161 X-Sequence-Number: 21931 > (Maybe other people are just > better at configuring their memory usage?) I don't mean to hijack the thread, but I am interested in learning the science behind configuring memory usage. A lot of the docs that I have found on this subject speak in terms of generalities and rules of thumb. Are there any resources that can show how to tune the kernels parameters to make use of all of the available memory and at the same time allow all services to get along?