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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster