Re: Re: Troubles with performances - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: Troubles with performances
Date
Msg-id 21391.980178246@sss.pgh.pa.us
Whole thread Raw
In response to Re: Troubles with performances  (Guillaume Lémery <glemery@comclick.com>)
List pgsql-general
Guillaume =?ISO-8859-1?Q?L=E9mery?= <glemery@comclick.com> writes:
> 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.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem with copy
Next
From: Guillaume Lémery
Date:
Subject: Re: Troubles with performances