Re: Postgres 9.1.8 - Out of memory: postgres killed after changing "checkoint_completion_target"

Zitat von Pierre Slania <pierre(dot)slania(at)gmail(dot)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(at)”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