Re: [PERFORM] ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine

2014-10-21 Thread Montana Low
increasing overcommit_ratio to 95 solved the problem, the box is now using it's memory as expected without needing to resort to swap. On Tue, Oct 21, 2014 at 3:55 PM, Montana Low wrote: > I didn't realize that about overcommit_ratio. It was at 50, I've changed > it to

Re: [PERFORM] ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine

2014-10-21 Thread Montana Low
On Tue, Oct 21, 2014 at 3:46 PM, Tomas Vondra wrote: > > Dne 22 Říjen 2014, 0:25, Montana Low napsal(a): > > I'm running postgres-9.3 on a 30GB ec2 xen instance w/ linux kernel > > 3.16.3. > > I receive numerous Error: out of memory messages in the log, which are >

[PERFORM] ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine

2014-10-21 Thread Montana Low
I'm running postgres-9.3 on a 30GB ec2 xen instance w/ linux kernel 3.16.3. I receive numerous Error: out of memory messages in the log, which are aborting client requests, even though there appears to be 23GB available in the OS cache. There is no swap on the box. Postgres is behind pgbouncer to