Postgres Pro
Downloads
Home   >   mailing lists

Re: Any better plan for this query?.. - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Any better plan for this query?..
Date
Msg-id alpine.DEB.2.00.0905121604110.2341@aragorn.flymine.org
Whole thread Raw
In response to Re: Any better plan for this query?..  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Any better plan for this query?..  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: Any better plan for this query?..  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Any better plan for this query?..
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Any better plan for this query?..