Re: View vs function

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: View vs function
Дата
Msg-id 423E57E5.4070405@samurai.com
обсуждение исходный текст
Ответ на Re: View vs function  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: View vs function
Список pgsql-performance
Bruno Wolff III wrote:
> Functions are just black boxes to the planner.

... unless the function is a SQL function that is trivial enough for the
planner to inline it into the plan of the invoking query. Currently, we
won't inline set-returning SQL functions that are used in the query's
rangetable, though. This would be worth doing, I think -- I'm not sure
how much work it would be, though.

-Neil

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

Предыдущее
От: "Stacy White"
Дата:
Сообщение: Re: What needs to be done for real Partitioning?
Следующее
От: "Stacy White"
Дата:
Сообщение: Re: What needs to be done for real Partitioning?