Re: Why not cache stable functions?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: falcon <falcon(at)intercable(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Why not cache stable functions?
Date: 2005-04-15 17:08:50
Message-ID: 20050415170850.GA7635@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Apr 15, 2005 at 12:54:24PM -0400, Tom Lane wrote:
> falcon <falcon(at)intercable(dot)ru> writes:
> > I think It would be useful to cache return values for stable
> > and immutable functions. Now thay are really called everytime.
>
> In most circumstances the overhead of searching such a cache would swamp
> any benefit we might get from it.

Maybe falcon would benefit from using pgmemcache in the first place ...

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"No es bueno caminar con un hombre muerto"

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-04-15 17:18:12 Re: Kerberos patch in the queue
Previous Message Tom Lane 2005-04-15 16:54:24 Re: Why not cache stable functions?