Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres crashes on insert in 40 different threads - Mailing list pgsql-admin

From Scott Ribe
Subject Re: postgres crashes on insert in 40 different threads
Date
Msg-id 6CDEA2B3-6C42-42D3-BAA8-AF98007012BB@elevated-dev.com
Whole thread Raw
In response to Re: postgres crashes on insert in 40 different threads  (Stéphane Schildknecht<stephane.schildknecht@postgresql.fr>)
Responses Re: postgres crashes on insert in 40 different threads
List pgsql-admin
Tree view 
On Aug 19, 2013, at 7:23 AM, Stéphane Schildknecht <stephane.schildknecht@postgresql.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@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-admin by date:

Previous
From: Stéphane Schildknecht
Date:
Subject: Re: postgres crashes on insert in 40 different threads
Next
From: Frank Lanitz
Date:
Subject: Re: postgres crashes on insert in 40 different threads