| From: | "Bjorn T Johansen" <btj(at)havleik(dot)no> |
|---|---|
| To: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Tomcat Connection Pool? |
| Date: | 2003-09-04 10:30:56 |
| Message-ID: | 10163.193.212.14.12.1062671456.squirrel@www.havleik.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
Well, that's one way to go. Guess I just have to try and fail... :)
Thx....
BTJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-09-04 10:30:59 | Re: Replaceing records |
| Previous Message | Peter Childs | 2003-09-04 10:26:40 | Re: Optimizer picks an ineffient plan |