From: | Guillaume Lémery <glemery(at)comclick(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Troubles with performances |
Date: | 2001-01-22 16:00:16 |
Message-ID: | 3A6C5910.6030002@comclick.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> Woops, I forgot to say that of course I use a connection pooling.
>> Just 5 connections are pooled.
>>> How many http connections per second are you getting?
>> 200
>
> Uh, so all of those http connections have to wait till one of the five
> database connections is free? Maybe that's your bottleneck. Try
> increasing the number of DB connections to something consistent with
> the traffic level.
Oddly, increasing the number of connections pooled doesn't increase
performance and if I create too much connections (e.g. 15 or 20,
performance decrease).
I don't know why... because all my queries try to access to the same
table and sometime the same record (a problem with the lock ??)
Thanx.
Guillaume
From | Date | Subject | |
---|---|---|---|
Next Message | Wade D. Oberpriller | 2001-01-22 16:28:25 | libpq++ |
Previous Message | Tom Lane | 2001-01-22 15:46:34 | Re: problem with copy |