2010/9/22 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> Hello
>
> I found probably hard problem in cooperation with window functions :(
>
> tuplesort_begin_datum creates child context inside aggcontext. This
> context is used for tuplestore. But when this function is called from
> WindowAgg_Aggregates context - someone drops all child context every
> iteration, and then tuplestore state is invalid. For this moment we
> can block using a median function as window function, but it should be
> solved better - if it is possible - I don't see inside window function
> implementation.

Does it happen when the window frame starts from not UNBOUNDED
PRECEDING? In those cases, nodeWindowAgg tries to discard all
aggregate contexts and to initialize the aggregate state. AFAIK the
memory context is brand-new although it was reset and its children
deleted, so if the function is well-formed and initializes its state
on NULL input, it doesn't cause a problem.


Regards,


-- 
Hitoshi Harada

In response to

• Re: wip: functions median and percentile at 2010-09-21 20:28:15 from Pavel Stehule

Responses

• Re: wip: functions median and percentile at 2010-09-22 04:44:58 from Pavel Stehule
• Re: wip: functions median and percentile at 2010-09-23 09:35:47 from Pavel Stehule

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2010-09-22 03:07:15
	Subject: Re: Multi-branch committing in git, revisited
Previous:	From: Bruce Momjian	Date: 2010-09-22 03:05:05
	Subject: Re: Multi-branch committing in git, revisited

pgsql-rrreviewers by date

Next:	From: Pavel Stehule	Date: 2010-09-22 04:36:24
	Subject: Re: wip: functions median and percentile
Previous:	From: Hitoshi Harada	Date: 2010-09-22 02:21:01
	Subject: Re: wip: functions median and percentile