Обсуждение: UDF and cache

Поиск
Список
Период
Сортировка

UDF and cache

От
"jungmin shin"
Дата:
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

Re: [HACKERS] UDF and cache

От
"Jim C. Nasby"
Дата:
On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote:
> 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.

It's not. See list archives for past discussions.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Re: UDF and cache

От
"Jim C. Nasby"
Дата:
And PLEASE do not post something to 3 lists; it's a lot of extra traffic
for no reason.

Moving to -hackers.

On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote:
> 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

--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)