Request a Demo
Home   >   mailing lists

Re: performance issue: logical operators are slow inside SQL function: missing optimalization? - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Date
Msg-id AANLkTinXXbWfDSxNPHKgspJatMLvXQMDKgtYDc6kNLVJ@mail.gmail.com
Whole thread Raw
In response to Re: performance issue: logical operators are slow inside SQL function: missing optimalization?  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Next
From: Magnus Hagander
Date:
Subject: Re: [BUGS] BUG #5305: Postgres service stops when closing Windows session