Re: postgres crashes on insert in 40 different threads

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres crashes on insert in 40 different threads
Date: 2013-08-19 13:43:28
Message-ID: 6CDEA2B3-6C42-42D3-BAA8-AF98007012BB@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Aug 19, 2013, at 7:23 AM, Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresql(dot)fr> wrote:

> As Laurenz said, you should have a look at documentation.
>
> It explains how you can lower the risk OOMKiller kills your PostgreSQL processes.
> 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.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Frank Lanitz 2013-08-19 14:59:14 Re: postgres crashes on insert in 40 different threads
Previous Message Stéphane Schildknecht 2013-08-19 13:23:34 Re: postgres crashes on insert in 40 different threads