Re: Re: Troubles with performances

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: Troubles with performances
Дата
Msg-id 21391.980178246@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Troubles with performances  (Guillaume Lémery <glemery@comclick.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: problem with copy
Следующее
От: Guillaume Lémery
Дата:
Сообщение: Re: Troubles with performances