[HACKERS] Re: [BUGS] Postgres bug (working with iserverd)

2001-05-14 Thread Vadim Mikheev
> > How subselects run queries again and again? > > They don't end and restart them; they just rescan them. If we had Thanks for recollection. > this substitute-a-new-tuple hack integrated into the Param mechanism, > then EvalPlanQual could use ExecReScan too, but at the moment no... I see.

[HACKERS] Re: [BUGS] Postgres bug (working with iserverd)

2001-05-14 Thread Tom Lane
"Vadim Mikheev" <[EMAIL PROTECTED]> writes: >> However, EvalPlanQual still leaks more memory than suits me --- >> auxiliary memory allocated by the plan nodes is not recovered. > Isn't plan shutdown supposed to free memory? Yeah, but it leaks all over the place; none of the plan node types bothe

[HACKERS] Re: [BUGS] Postgres bug (working with iserverd)

2001-05-14 Thread Vadim Mikheev
> However, EvalPlanQual still leaks more memory than suits me --- > auxiliary memory allocated by the plan nodes is not recovered. > I think the correct way to implement it would be to create a new > memory context for each level of EvalPlanQual execution and use > that context as the "per-query c

[HACKERS] Re: [BUGS] Postgres bug (working with iserverd)

2001-05-14 Thread Tom Lane
I wrote: > The direct cause of the problem is that EvalPlanQual isn't completely > initializing the estate that it sets up for re-evaluating the plan. > In particular it's not filling in es_result_relations and > es_num_result_relations, which need to be set up if the top plan node > is an Append.