pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUDF and cache
3+ messages / 2 participants
[nested] [flat]
* UDF and cache
@ 2006-10-18 21:15 jungmin shin <jungmin.shin@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: jungmin shin @ 2006-10-18 21:15 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; pgsql-performance; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [HACKERS] UDF and cache
@ 2006-10-18 21:16 Jim C. Nasby <jim@nasby.net>
parent: jungmin shin <jungmin.shin@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jim C. Nasby @ 2006-10-18 21:16 UTC (permalink / raw)
To: jungmin shin <jungmin.shin@gmail.com>; +Cc: pgsql-hackers@postgresql.org; pgsql-performance; pgsql-general@postgresql.org
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)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: UDF and cache
@ 2006-10-18 21:19 Jim C. Nasby <jim@nasby.net>
parent: jungmin shin <jungmin.shin@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jim C. Nasby @ 2006-10-18 21:19 UTC (permalink / raw)
To: jungmin shin <jungmin.shin@gmail.com>; +Cc: pgsql-hackers@postgresql.org
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)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-10-18 21:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-18 21:15 UDF and cache jungmin shin <jungmin.shin@gmail.com>
2006-10-18 21:16 ` Jim C. Nasby <jim@nasby.net>
2006-10-18 21:19 ` Jim C. Nasby <jim@nasby.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox