Re: Terminating a SETOF function call sequence

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Terminating a SETOF function call sequence
Дата
Msg-id 7126.1108654133@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Terminating a SETOF function call sequence  (Thomas Hallgren <thhal@mailblocks.com>)
Ответы Re: Terminating a SETOF function call sequence  (Thomas Hallgren <thhal@mailblocks.com>)
Список pgsql-hackers
Thomas Hallgren <thhal@mailblocks.com> writes:
> My question is, what happens when the evaluator doesn't need more rows? 
> Will it:
> a) call the function with call_cntr >= max_calls?
> b) continue calling until the set is exhausted anyway?
> c) simply stop calling?

(c)

> a) seems unlikely since max_calls is set by the user, b) doesn't seem 
> very optimal, and c) would be very bad since it doesn't give me any 
> chance to release the resources that where used in order to produce the 
> rows.

This is what RegisterExprContextCallback is for.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: win32 performance - fsync question
Следующее
От: lsunley@mb.sympatico.ca
Дата:
Сообщение: Re: win32 performance - fsync question