Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VBPkA-0005Ax-3b for pgsql-admin@arkaria.postgresql.org; Mon, 19 Aug 2013 13:43:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VBPk9-00050p-Iq for pgsql-admin@arkaria.postgresql.org; Mon, 19 Aug 2013 13:43:37 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VBPk8-0004ys-60 for pgsql-admin@postgresql.org; Mon, 19 Aug 2013 13:43:36 +0000 Received: from asbnvacz-mailrelay01.megapath.net ([207.145.128.243]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VBPk4-0006jn-Tu for pgsql-admin@postgresql.org; Mon, 19 Aug 2013 13:43:35 +0000 Received: from mail6.sea5.speakeasy.net (mail6.sea5.speakeasy.net [69.17.117.50]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id 8FF441EE5057 for ; Mon, 19 Aug 2013 09:43:31 -0400 (EDT) Received: (qmail 30826 invoked from network); 19 Aug 2013 13:43:31 -0000 Received: by simscan 1.4.0 ppid: 11051, pid: 19988, t: 1.2060s scanners: clamav: 0.88.2/m:52/d:10739 spam: 3.0.4 Received: from unknown (HELO [192.168.4.16]) (sribe@elevated-dev.com@[205.168.220.137]) (envelope-sender ) by mail6.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 19 Aug 2013 13:43:29 -0000 Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Mac OS X Mail 6.5 \(1508\)) Subject: Re: postgres crashes on insert in 40 different threads From: Scott Ribe In-Reply-To: <52121C56.3020101@postgresql.fr> Date: Mon, 19 Aug 2013 07:43:28 -0600 Content-Transfer-Encoding: quoted-printable Message-Id: <6CDEA2B3-6C42-42D3-BAA8-AF98007012BB@elevated-dev.com> References: <52121C56.3020101@postgresql.fr> To: "pgsql-admin@postgresql.org" X-Mailer: Apple Mail (2.1508) X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on mail6.sea5 X-Spam-Level: X-Spam-Status: No, score=0.5 required=8.0 tests=TO_ADDRESS_EQ_REAL autolearn=disabled version=3.0.4 X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Aug 19, 2013, at 7:23 AM, St=E9phane Schildknecht wrote: > As Laurenz said, you should have a look at documentation. >=20 > It explains how you can lower the risk OOMKiller kills your PostgreSQL pr= ocesses. > 1. You can set vm.overcommit_memory to 2 in sysctl.conf > 2. You can adjust the value of oom_score_adj in startup script to prevent= OOMKiller to kill Postmaster > 3. You can lower shared_buffers, work_mem and max_connections. 4. Use pgbouncer, and radically lower the number of pg connections used. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin