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

From Greg Stark
Subject Re: Any better plan for this query?..
Date
Msg-id 4136ffa0905121215s19548b7am24cd25b760c648e@mail.gmail.com
Whole thread Raw
In response to Re: Any better plan for this query?..  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Tue, May 12, 2009 at 5:49 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> See previous discussions.  IIRC, there are two killer points:
>
> 1. There is no (portable) way to pass the connection from the postmaster
> to another pre-existing process.

The Apache model is to have all the backends call accept. So incoming
connections don't get handled by a single master process, they get
handled by whichever process the kernel picks to receive the
connection.

--
greg

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Any better plan for this query?..
Next
From: Angel Alvarez
Date:
Subject: superlative missuse