Yes, this is oom Firstly it killed httpd and then postmaster. But who took all the memory? I see there Free swap: 0Kb in the messages log - was it a reason?
Sounds likely.
I have 1GB of RAM. For shared memory I took about 262MB.
/etc/sysctl.conf =================== #shared memory increase to 262 MB kernel.shmmax=268435456 kernel.shmall=268435456 ====================
Postgresql.conf ======================= Max_connections = 100 shared_buffers = 20000 # min 16, at least max_connections*2, 8KB
What's your sort-mem? That is the memory per-sort, and you can have several sorts in one query.
Also - might be worth checking if you have reasonable memory constraints for Apache / PHP (if you are running it).
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
