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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Дата
Msg-id 16289.1283092264@sss.pgh.pa.us
обсуждение исходный текст
Ответ на performance issue: logical operators are slow inside SQL function: missing optimalization?  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: performance issue: logical operators are slow inside SQL function: missing optimalization?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Pavel Stehule <pavel.stehule@gmail.com> writes:
> I testing a simple use case and I was surprised with very slow
> execution of SQL functions

The one case is inline-able and the other not (because it would result
in double evaluation of the volatile function random()).
See EXPLAIN VERBOSE.
        regards, tom lane

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

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