On Tue, 2006-12-26 at 10:47 -0500, Tom Lane wrote:
> As you can probably guess, I'm leaning to #3, but wanted to see if
> anyone had an objection or a better idea.
Is it possible to allocate the subquery in a child context of the main
query, so that it is technically a different context, yet can be freed
simultaneously?
Hierarchical queries seem like they'd need something like that?
Or should we have the context of a shared context, so that the subquery
can put info somewhere where the main context can read it?
I like the idea of freeing contexts as early as possible. We might not
do that now, but we might like to in the future.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com