Zitat von Pierre Slania <pierre.slania@xxxxxxxxx>:
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:
smime.p7s
Description: S/MIME Cryptographic Signature