Re: [GENERAL] turn off cache option

2007-04-05 Thread Ragnar
On fim, 2007-04-05 at 16:31 -0400, jungmin shin wrote: > > I'm executing a query invoking a UDF. > It looks that Postgres use a cache for executing UDFs. Postgresql is not using a cache specially for executing UDFs, apart from only compiling the function once for each session. > > select a()

[GENERAL] turn off cache option

2007-04-05 Thread jungmin shin
Hello, I'm executing a query invoking a UDF. It looks that Postgres use a cache for executing UDFs. For example, select a() a is a UDF. Excution time of above statement is different each time. What is happening inside of the Postgres when I invoke a UDF in a query? It is taking 200ms or 116