Re: Tomcat Connection Pool? - Mailing list pgsql-general

From Paul Thomas
Subject Re: Tomcat Connection Pool?
Date
Msg-id 20030904105933.G14868@bacon
Whole thread Raw
In response to Re: Tomcat Connection Pool?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: Tomcat Connection Pool?
List pgsql-general
On 03/09/2003 22:56 Bjørn T Johansen wrote:
> Oki, thx... Any ideas to what is sensible values also?
> (Like number of maxIdle compared to maxActive, etc..)
>

I think sensible values are going to be very dependent on the number of
requests. One way to find out might be to write a little utility to count
the number of back-end postgres connections and have it run every 3 or 4
seconds. That would give you an idea of the maximum and average number of
connections being used.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Replaceing records
Next
From: Csaba Nagy
Date:
Subject: Re: Replaceing records