turn off cache option - Mailing list pgsql-general

From jungmin shin
Subject turn off cache option
Date
Msg-id cd77360b0704051331g372783fay199b4616df2fba85@mail.gmail.com
Whole thread Raw
Responses Re: turn off cache option  (Ragnar <gnari@hive.is>)
List pgsql-general

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

pgsql-general by date:

Previous
From: "Michael Nolan"
Date:
Subject: Seg fault in pg_dump?
Next
From: Alvaro Herrera
Date:
Subject: Re: Seg fault in pg_dump?