Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 498E79FB4B5; Tue, 6 Mar 2007 04:29:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 35730-03; Tue, 6 Mar 2007 04:29:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from serv1.oss.ntt.co.jp (serv1.oss.ntt.co.jp [222.151.198.98]) by postgresql.org (Postfix) with ESMTP id 7F3C19FB35D; Tue, 6 Mar 2007 04:29:28 -0400 (AST) Received: from [127.0.0.1] (unknown [172.17.1.114]) by serv1.oss.ntt.co.jp (Postfix) with ESMTP id DFF6F104001; Tue, 6 Mar 2007 17:29:26 +0900 (JST) Message-ID: <45ED2624.80704@oss.ntt.co.jp> Date: Tue, 06 Mar 2007 17:28:20 +0900 From: Toru SHIMOGAKI User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-patches@postgresql.org CC: pgsql-docs@postgresql.org Subject: doc patch for Linux memory overcommit Content-Type: multipart/mixed; boundary="------------060201030804060702050806" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200703/4 X-Sequence-Number: 4175 This is a multi-part message in MIME format. --------------060201030804060702050806 Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit The attached is a doc patch for Linux memory overcommit and an additional way of avoiding a problem that postmaster is suddenly killed by OOM-Killer. http://archives.postgresql.org/pgsql-docs/2007-03/msg00000.php Best regards, -- Toru SHIMOGAKI --------------060201030804060702050806 Content-Type: text/plain; name="overcommit_doc.patch" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="overcommit_doc.patch" KioqIHJ1bnRpbWUuc2dtbC5vcmlnCTIwMDctMDMtMDYgMTY6MjM6MTAuMDAwMDAwMDAwICsw OTAwCi0tLSBydW50aW1lLnNnbWwJMjAwNy0wMy0wNiAxNzoxNDozOC4wMDAwMDAwMDAgKzA5 MDAKKioqKioqKioqKioqKioqCioqKiAxMjA3LDEyMTUgKioqKgogICAgIDwvcGFyYT4KICAK ICAgICA8cGFyYT4KISAgICAgT24gTGludXggMi42IGFuZCBsYXRlciwgYSBiZXR0ZXIgc29s dXRpb24gaXMgdG8gbW9kaWZ5IHRoZSBrZXJuZWwncwohICAgICBiZWhhdmlvciBzbyB0aGF0 IGl0IHdpbGwgbm90IDxxdW90ZT5vdmVyY29tbWl0PC8+IG1lbW9yeS4gIFRoaXMgaXMKISAg ICAgZG9uZSBieSBzZWxlY3Rpbmcgc3RyaWN0IG92ZXJjb21taXQgbW9kZSB2aWEgPGNvbW1h bmQ+c3lzY3RsPC9jb21tYW5kPjoKICA8cHJvZ3JhbWxpc3Rpbmc+CiAgc3lzY3RsIC13IHZt Lm92ZXJjb21taXRfbWVtb3J5PTIKICA8L3Byb2dyYW1saXN0aW5nPgotLS0gMTIwNywxMjI0 IC0tLS0KICAgICA8L3BhcmE+CiAgCiAgICAgPHBhcmE+CiEgICAgIEluIGFkZGl0aW9uLCBp bmNyZWFzaW5nIHN3YXAgYXJlYSBvbiBPUyBjYW4gYXZvaWQgdGhlIHByb2JsZW0gdG9vLgoh ICAgICBPdXQtb2YtTWVtb3J5LUtpbGxlcihPT00tS2lsbGVyKSBpcyBpbnZva2VkIHdoZW5l dmVyIHBoeXNpY2FsIG1lbW9yeSBhbmQgCiEgICAgIHN3YXAgYXJlYSBhcmUgZXhoYXVzdGVk LiBJbmNyZWFzaW5nIHN3YXAgYXJlYSBpcyBlYXN5IHRvIHNldCBhbmQgaXQgCiEgICAgIGRv ZXNuJ3QgaGF2ZSBoYXJtZnVsIGluZmx1ZW5jZS4KISAgICA8L3BhcmE+CiEgCiEgICAgPHBh cmE+CiEgICAgIE9uIExpbnV4IDIuNiBhbmQgbGF0ZXIsIGEgYmV0dGVyIHNvbHV0aW9uIGlz IHRvIG1vZGlmeSB0aGUga2VybmVsJ3MgCiEgICAgIGJlaGF2aW9yIHNvIHRoYXQgaXQgd2ls bCBub3QgPHF1b3RlPm92ZXJjb21taXQ8Lz4gbWVtb3J5LiAgVGhvdWdoIHRoaXMgCiEgICAg IHNldHRpbmcgY2FuJ3QgcHJldmVudCBPT00tS2lsbGVyIGZyb20gaW52b2tpbmcgZGlyZWN0 bHksIHdlIGNhbiBleHBlY3QgCiEgICAgIGhlYWx0eSBtZW1vcnkgYWxsb2NhdGlvbi4gVGhp cyBpcyBkb25lIGJ5IHNlbGVjdGluZyBzdHJpY3Qgb3ZlcmNvbW1pdCAKISAgICAgbW9kZSB2 aWEgPGNvbW1hbmQ+c3lzY3RsPC9jb21tYW5kPjoKICA8cHJvZ3JhbWxpc3Rpbmc+CiAgc3lz Y3RsIC13IHZtLm92ZXJjb21taXRfbWVtb3J5PTIKICA8L3Byb2dyYW1saXN0aW5nPgo= --------------060201030804060702050806--