Spike in number of database connections

(Dorian Borg) #1
Recently we are encountering a problem where the number of database connections spike all of a sudden, causing the server to exceed the connects limit. We have increased the number of postgres connections to 400 in order to go around this issue for the moment. The connections seems to remain IDLE.
 
We are looking into the possibility of setting pgBouncer at the moment.
 
Can somebody provide some recommendations about his issue?
 
Running Squiz Matrix:  4.18.3
postgres version: 9.3
 
thanks
(Tom Chadwin) #2

If a symptom of this is the "superusers exceeded" error in _admin, then we get it periodically, too. How are you handling your sessions? If memcache, it can be tweaked to try to minimize this, though obviously this can conceivably result in a degraded admin experience.

(Nic Hubbard) #3

We get this issue sometimes as well.