From: | Rodrigo Pereira da Silva <rodrigo(at)paripassu(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Too much clients connected to the PostgreSQL Database |
Date: | 2012-10-29 19:29:54 |
Message-ID: | 508ED932.3060707@paripassu.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Guys,
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).
It's interesting, because we didn't have this problem with
Postgresql 8.3.
I don't know if that's can be caused by any postgresql internal
task, like, auto-vaccum.
Someone knows if there is anything new in PostgreSQL 9.1 that
it's probably consuming connections? Is there any default approach to
proceed with this kind of problem? I'm connected of increasing the max
connections and do not resolve the problem or decrease performance.
Thanks in advance,
------------------------------------------------------------------------
*Rodrigo Pereira da Silva*
rodrigo(at)paripassu(dot)com(dot)br <mailto:rodrigo(at)paripassu(dot)com(dot)br>
http://www.paripassu.com.br
Rua Coronel Luis Caldeira, nº 67, Bloco 1, Sala 3A
88034-110 . Florianópolis . SC
Tel. (48) 3207-5755
------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2012-10-29 20:58:04 | Re: Too much clients connected to the PostgreSQL Database |
Previous Message | hartrc | 2012-10-29 19:10:57 | pg_archivecleanup - clean up files with extensions |