Re: Random server overload

Hello,

It's me again..

Log_connection inspection didn't help to find the cause, the connections come from our app-servers as usual..

Btw we have the max pool size of web application 50 connections and since we have 4 instances of application running  it makes max 200.

I don't really get how the database pool gets full when application can use 200 connections max and postrgesql config has set to 250 max connections ?

Autovacuum and master-slave replication shouldn't use many connections also.

Please explain that, maybe i'm missing something.

Should we try to reduce this limit to 40 per application?