Re: performance issue: logical operators are slow inside SQL function: missing optimalization?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Дата
Msg-id AANLkTinXXbWfDSxNPHKgspJatMLvXQMDKgtYDc6kNLVJ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: performance issue: logical operators are slow inside SQL function: missing optimalization?  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
Список pgsql-hackers
Дерево обсуждения 
Hello

2010/8/29 Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>:
> On 29 Aug 2010, at 13:20, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>>
>> Is strange - so slow function can be replaced by plpgsql function and
>> it's faster
>
> All your SQL language functions were VOLATILE.
>

It's not a problem - planner see inside SQL function - so you don't
need set a flags.

Regards

Pavel Stehule

>
> Regards,
> Marko Tiikkaja
>

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

Предыдущее
От: Marko Tiikkaja
Дата:
Сообщение: Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: [BUGS] BUG #5305: Postgres service stops when closing Windows session