Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E4043B6065C for ; Tue, 31 May 2011 15:35:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 70974-07-3 for ; Tue, 31 May 2011 18:35:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from SVRMAILCAS2.padres.com (unknown [209.242.156.253]) by mail.postgresql.org (Postfix) with ESMTP id 92C63B60ADF for ; Tue, 31 May 2011 15:35:30 -0300 (ADT) Received: from SVRMAIL2.padres.com ([fe80::cd8c:f07:aff2:301c]) by SVRMAILCAS2.padres.com ([fe80::d595:a7e8:fd99:3de9%10]) with mapi id 14.01.0289.001; Tue, 31 May 2011 11:35:29 -0700 From: Wells Oliver To: Kevin Grittner , "pgsql-admin@postgresql.org" Subject: Re: Server crash... trying to figure it out Thread-Topic: [ADMIN] Server crash... trying to figure it out Thread-Index: AQHMH7nUln5n2rVvhUaavmicBoBi/5Snt+aAgAAA+IA= Date: Tue, 31 May 2011 18:35:28 +0000 Message-ID: <5366FE31-4E2E-41C6-94F7-90C9D0477C44@padres.com> References: <509F1BCA-2A75-41F4-87F5-EBD098023D71@padres.com> <4DE4EDC5020000250003DF1B@gw.wicourts.gov> In-Reply-To: <4DE4EDC5020000250003DF1B@gw.wicourts.gov> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.31.12.124] Content-Type: text/plain; charset="us-ascii" Content-ID: Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201105/188 X-Sequence-Number: 37625 On May 31, 2011, at 11:31 AM, Kevin Grittner wrote: You're probably overcommitting memory and running afoul of the oom killer. You've got an actual 12MB, but you can easily allocate up to shared_buffers + (user_connections * work_mem), which is 18.5 GB. I would start by reducing shared_buggers to 3GB or less, and cut work_mem in half. Then I would get a connection pooler set up to funnel 200 client-side connections through a pool of 10 or 20 database connections. Then I would try edging up work_mem while monitoring performance and memory usage. -Kevin Thanks for the response- great food for thought. Do you have any recommenda= tions on a pg connection pooler? -- Wells Oliver Architect, Baseball Systems 619-795-5359 San Diego Padres | 100 Park Boulevard | San Diego CA 92101