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()
> 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 11688ms .
Postgresql relies on the filesystem and operating
system to cache fisk buffers efficiently, so you are probably
just seeing the effects of that, assuming that your function is
doing the same thing each time.
>
> If a cache is used for this execution , can I turn off the cache
> option?
why would you want to do that?
gnari
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
