Rodrigo Pereira da Silva wrote: > We have about 10 web applications deployed in a Tomcat 7.0 > accessing a Postgresql 9.1 database. We do use connection pooling. > We have the max_connections parameter set to 200 connections, > however, we are reaching the max connections sporadically(about 4 > time/day).
What is the pooler's maxActive setting? (It should be less than the PostgreSQL max_connections setting.) BTW, 200 seems alwfully high unless a *really* high end machine. You may have fewer timeouts if you avoid swamping the server with a "thundering herd" of requests. http://wiki.postgresql.org/wiki/Number_Of_Database_Connections -Kevin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
