Search Postgresql Archives

turn off cache option

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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 11688ms .
There is huge differences.
 
If a cache is used for this execution , can I turn off the cache option?
 
Thanks,
 
 

--
Jungmin Shin

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux