Re: Any better plan for this query?..

Поиск
Список
Период
Сортировка
От Matthew Wakeling
Тема Re: Any better plan for this query?..
Дата
Msg-id alpine.DEB.2.00.0905121604110.2341@aragorn.flymine.org
обсуждение исходный текст
Ответ на Re: Any better plan for this query?..  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Any better plan for this query?..
Re: Any better plan for this query?..
Список pgsql-performance
On Tue, 12 May 2009, Simon Riggs wrote:
>> won't connect operations be all handled by a
>> single thread - the parent postmaster?
>
> No, we spawn then authenticate.

But you still have a single thread doing the accept() and spawn. At some
point (maybe not now, but in the future) this could become a bottleneck
given very short-lived connections.

Matthew

--
 -. .-.   .-. .-.   .-. .-.   .-. .-.   .-. .-.   .-. .-.   .-.
 ||X|||\ /|||X|||\ /|||X|||\ /|||X|||\ /|||X|||\ /|||X|||\ /|||
 |/ \|||X|||/ \|||X|||/ \|||X|||/ \|||X|||/ \|||X|||/ \|||X|||/
 '   `-' `-'   `-' `-'   `-' `-'   `-' `-'   `-' `-'   `-' `-'

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Any better plan for this query?..
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Any better plan for this query?..