Re: LANGUAGE sql functions don't use the custom plan logic

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: LANGUAGE sql functions don't use the custom plan logic
Дата
Msg-id 20150710135902.GK26521@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: LANGUAGE sql functions don't use the custom plan logic  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 2015-07-10 09:52:30 -0400, Tom Lane wrote:
> There's a whole lot of ways in which the current implementation of
> SQL-language functions leaves things to be desired.

Yea.

> What did you run into exactly?

A generic plan was used on a partitioned table.  Normally the function
could be inlined so that wasn't noticeable, but in one case it
wasn't... It's confusing if all invocations of the same function are
reasonably fast, but one, with the numerically same values passed down,
isn't.

Andres



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

Предыдущее
От: "Shulgin, Oleksandr"
Дата:
Сообщение: Re: [PATCH] Generalized JSON output functions
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [PATCH] Generalized JSON output functions