Re: Re: Troubles with performances

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guillaume Lémery <glemery(at)comclick(dot)com>
Cc: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: Troubles with performances
Date: 2001-01-22 15:44:06
Message-ID: 21391.980178246@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Guillaume =?ISO-8859-1?Q?L=E9mery?= <glemery(at)comclick(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-22 15:46:34 Re: problem with copy
Previous Message Richard Huxton 2001-01-22 15:41:20 Re: Silencing 'NOTICE' messages for PRIMARY KEY