Re: [GENERAL] UDF in C slow

2012-05-11 Thread Inanc Seylan
es of both queries. So I guess it was not the function that was the problem in the end. Thanks a lot! Inanc On 5/11/12 5:55 PM, Tom Lane wrote: Inanc Seylan writes: It is IMMUTABLE. I attach the output of EXPLAIN both with and without the simple function (returning true only) in the query.

Re: [GENERAL] UDF in C slow

2012-05-11 Thread Inanc Seylan
It is IMMUTABLE. I attach the output of EXPLAIN both with and without the simple function (returning true only) in the query. On 5/11/12 4:21 PM, Alban Hertroys wrote: On 11 May 2012 15:57, Inanc Seylan wrote: Hi all, I have implemented a user-defined function in C that returns a boolean

[GENERAL] UDF in C slow

2012-05-11 Thread Inanc Seylan
Hi all, I have implemented a user-defined function in C that returns a boolean value after some computation. Now I have a query Q such that when I specify the function in the WHERE clause of Q, Q runs in 40 secs and if I don't use the function it runs in 4 secs. Then I thought that my impleme