Re: [ADMIN] concat_ws

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [ADMIN] concat_ws
Дата
Msg-id 1680.1059949492@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: [ADMIN] concat_ws  (Joe Conway <mail@joeconway.com>)
Список pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> Tom Lane wrote:
>> It seems to be running out of memory.

> Also worth noting, without STRICT, even a plain EXPLAIN *without*
> ANALYZE causes the problem to show itself.

Yeah.  The problem is that the SQL function inliner generates an
enormous expression tree from this function definition.  7.3 had no
inliner so no problem.

I am not sure what to do about it --- the only idea that comes to mind
is to put an arbitrary limit (of, say, 5 or 10 function calls) on the
depth of inlining expansion.  That seems like a pretty ugly answer
... anyone have a better one?

Your definition of concat_ws bears some passing resemblance to the
infamous Ackermann's function, btw.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SQL2003 GENERATED ... AS ... syntax
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: SQL2003 GENERATED ... AS ... syntax