Re: Postgres 9.1.8 - Out of memory: postgres killed after changing "checkoint_completion_target" - Mailing list pgsql-admin

From lst_hoe02@kwsoft.de
Subject Re: Postgres 9.1.8 - Out of memory: postgres killed after changing "checkoint_completion_target"
Date
Msg-id 20141208150029.Horde.F0E_48Uk8iKCIkyEwESGiA7@webmail.kwsoft.de
Whole thread Raw
In response to Postgres 9.1.8 - Out of memory: postgres killed after changing "checkoint_completion_target"  (Pierre Slania <pierre.slania@gmail.com>)
List pgsql-admin
Zitat von Pierre Slania <pierre.slania@gmail.com>:

> Hi,
>
>
> Application Server :
>
> ----------------------------
>
> AS JBoss  7.1.1.Final with a connection pool
>
> Postgres version running in production
>
> ------------------------------------------------
>
> PostgreSQL 9.1.8 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
> (Debian 4.4.5-8) 4.4.5, 64-bit
>
>
>
> OS Server production
>
> --------------------------
>
> Linux “myserver” 3.2.0-4-amd64 #1 SMP Debian 3.2.51-1 x86_64 GNU/Linux
>
>
> The following memories value was done today:
>
> postgres@”myserver”:/var/log/postgresql$ free -m
>
>                      total        used         free        shared
> buffers     cached
>
> Mem:         32115      29498       2617          0            110
>            20128
>
> -/+ buffers/cache:       9258      22857
>
> Swap:            0          0          0
>
> No swap allowed in this server

Fix this. Configuring no "Swap" is a common misconception:
http://serverfault.com/questions/49222/centos-how-much-swap-for-16gb-of-ram/332205#332205

>
>  Problem :
>
> ------------
>
> Dec  4th 10:42:41 “myserver” kernel: [7604991.147522] Out of memory: Kill
> process 2904 (postgres) score 217 or sacrifice child

This is a error in your configuration, not in PostgreSQL. PostgreSQL
is the victim of the OOM nearly for sure not the reason.

See also in
http://www.postgresql.org/docs/9.1/static/kernel-resources.html
(17.4.3 Linux Memory Overcommit)

Regards

Andreas



Attachment

pgsql-admin by date:

Previous
From: Pierre Slania
Date:
Subject: Postgres 9.1.8 - Out of memory: postgres killed after changing "checkoint_completion_target"
Next
From: Natalie Wenz
Date:
Subject: autovacuum to prevent wraparound question