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 по дате отправления: