Tom Lane <t...@sss.pgh.pa.us> writes: > It's really not much different from a function call with subplans as > functions. The PARAM_EXEC stuff looks just like 1950's era > non-reentrant function parameter passing mechanisms, back before anybody > had thought of recursive functions and they passed a function's > parameters in fixed storage locations. It's okay for this because > subplan trees are never recursive ...
<hand waving alert> How much does this stuff is dependent on the current state of the backend? If not that much, maybe the planner could consider costs of having another backend started to handle the subplan. We'd need a tuplestore or some other place to exchange results (a unix style pipe maybe, but we do support windows as a platform), and a special executor mode for running a subplan, maybe more than once. Oh, and a way to share the same snapshot in more than one backend too, but that's being worked on I think. Ok that's a far stretch from the question at hand, but would that be a plausible approach to have parallel queries in PostgreSQLÂ ? Regards, -- dim -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
