Re: Performance of pl/pgsql functions?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Performance of pl/pgsql functions?
Дата
Msg-id CAFj8pRAdYL1-hCxH+QSZQKHt9YnoaOiGkfX4cNc9mzUTimcs1w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance of pl/pgsql functions?  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Performance of pl/pgsql functions?
Список pgsql-general
Дерево обсуждения 
2012/9/14 John R Pierce <pierce@hogranch.com>:
> On 09/13/12 10:17 PM, Wells Oliver wrote:
>>
>> Do these tend to perform well? I have some simple formulas in functions
>> like so:
>
>
> if you code your function in SQL instead of plpgsql, and mark it immutable,
> it can be inlined by the planner.

you don't need to mark SQL functions - it is not black box for
optimizer and usually better is don't mark SQL functions.

Regards

Pavel

>
>
>
> --
> john r pierce                            N 37, W 122
> santa cruz ca                         mid-left coast
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

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