Re: Memory Settings....

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Memory Settings....
Дата
Msg-id 471C98BD.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Memory Settings....  (Lee Keel <lee.keel@uai.com>)
Список pgsql-performance
>>> On Mon, Oct 22, 2007 at 11:10 AM, in message
<76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int>, Lee Keel
<lee.keel@uai.com> wrote:

> there will probably be no more than 50 simultaneous requests.

> Dual-Quad Core 2.33GHz

My benchmarks have indicated that you want to keep the number of
active queries at or below four times the number of CPUs.  You might
want to consider some form of connection pooling which can queue the
requests to achieve that.  It can boost both the throughput and the
response time.

-Kevin




В списке pgsql-performance по дате отправления:

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: Memory Settings....
Следующее
От: Adrian Demaestri
Дата:
Сообщение: Seqscan