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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux