Re: Support Parallel Query Execution in Executor - Mailing list pgsql-hackers

From Markus Schiltknecht
Subject Re: Support Parallel Query Execution in Executor
Date
Msg-id 1144693574.4895.2.camel@localhost.localdomain
Whole thread Raw
In response to Re: Support Parallel Query Execution in Executor  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Hi,

On Mon, 2006-04-10 at 13:36 -0400, Alvaro Herrera wrote:
> An idea arising in chat with Joshua Drake:  the retargetting code, if it
> turns out to work and not be excessively expensive, could also be useful
> to implement a server-side "connection pooling" of sorts: the postmaster
> could keep idle backends and retarget them to a database that receives
> an incoming connection.  However, we'd also need a mechanism to clean
> all backend state previous to reusing a connection, to leave it "as
> new" (no prepared statements, WITH HOLD cursors, etc.)

I suspect that's what I was calling 'pre-forking'. Please also note that
this would be the most difficult of my three examples (by difficulty of
implementation).

Regards

Markus




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Support Parallel Query Execution in Executor
Next
From: "Luke Lonergan"
Date:
Subject: Re: Support Parallel Query Execution in Executor