Hi, I'm using and Amazon ec2 instance with the following spec and the application that I'm running uses a postgres DB 9.1. The app has 3 main cron jobs.
Ubuntu 12, High-Memory Extra Large Instance 17.1 GB of memory 6.5 EC2 Compute Units (2 virtual cores with 3.25 EC2 Compute Units each) 420 GB of instance storage 64-bit platform
I've changed the main default values under file postgresql.conf to: shared_buffers = 4GB work_mem = 16MB wal_buffers = 16MB checkpoint_segments = 32 effective_cache_size = 8GB
When I run the app, after an hour or two, free -m looks like below ans the crons can't run due to memory loss or similar (i'm new to postgres and db admin). Thanks!
**errors: DBI connect('database=---;host=localhost','postgres',...) failed: could not fork new process for connection: Cannot allocate memory could not fork new process for connection: Cannot allocate memory
and execute failed: ERROR: out of memory DETAIL: Failed on request of size 968. [for Statement " SELECT DISTINCT....