turn off cache option

From: "jungmin shin" <jungmin(dot)shin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: turn off cache option
Date: 2007-04-05 20:31:14
Message-ID: cd77360b0704051331g372783fay199b4616df2fba85@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-04-05 20:48:00 Re: Seg fault in pg_dump?
Previous Message Michael Nolan 2007-04-05 19:43:19 Seg fault in pg_dump?