Re: LOG: could not fork new process for connection: Cannot allocate memory

On 8/25/16 7:45 PM, Ahsan Ali wrote:

Please don't top-post; it's harder to read.

On Thu, Aug 25, 2016 at 5:29 PM, John R Pierce <pierce@hogranch.com
<mailto:pierce@hogranch.com>> wrote:
    so there were 1818 postgres client processes at the time it coudln't
    create a new process.   thats certainly a larger number than I've
    ever run.   if I have client software that has lots and lots of idle
    connections, I use a connection pooler like pgbouncer, in
    transaction mode.

While not the most ideal, people pay way too much attention to large connection counts. It's not *that* big a deal.

we have a pooling on the application level. however we never had this
issues before this start happning since last couple of days in past we
had over 2300 sessions but no issues.

Well, if I'm reading your original post correctly, this on a server that only has 252MB of memory, which is *very* small. Even so, according to `free` there's 175MB cached, which should become available as necessary.