UDF and cache

From: "jungmin shin" <jungmin(dot)shin(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: UDF and cache
Date: 2006-10-18 21:15:13
Message-ID: cd77360b0610181415j2600c09fv973107396491ca7f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

Hello all,

I read a paper, which is Query optimization in the presence of Foreign
Functions.
And the paper , there is a paragraph like below.

In order to reduce the number of invocations, caching the results of
invocation was suggested in Postgres.

I'd like to know in detail about how postgres is maintaing the cache of
UDFs.

Thanks,
Jungmin

--
Jungmin Shin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-18 21:16:54 Re: [HACKERS] UDF and cache
Previous Message Jim C. Nasby 2006-10-18 21:08:53 Re: Real time query analyzer

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-18 21:16:54 Re: [HACKERS] UDF and cache
Previous Message Tom Lane 2006-10-18 21:11:41 Re: Performance/Security question on caching function OIDs for a connection

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-18 21:16:54 Re: [HACKERS] UDF and cache
Previous Message Jeff Davis 2006-10-18 21:07:28 Re: Postgresql 8.1.4 - performance issues for select on