Re: Any better plan for this query?..

Поиск
Список
Период
Сортировка
От Glenn Maynard
Тема Re: Any better plan for this query?..
Дата
Msg-id bd36f99e0905121452j47c60981h12a9ac2e7f0bc224@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Any better plan for this query?..  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Any better plan for this query?..  (Dimitri <dimitrik.fr@gmail.com>)
Re: Any better plan for this query?..  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
I'm sorry, but I'm confused.  Everyone keeps talking about connection
pooling, but Dimitri has said repeatedly that each client makes a
single connection and then keeps it open until the end of the test,
not that it makes a single connection per SQL query.  Connection
startup costs shouldn't be an issue.  Am I missing something here?
test(N) starts N clients, each client creates a single connection and
hammers the server for a while on that connection.  test(N) is run for
N=1,2,4,8...256.  This seems like a very reasonable test scenario.

--
Glenn Maynard

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Any better plan for this query?..
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: AMD Shanghai versus Intel Nehalem