Re: PL Caching in TopTransactionContext

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: yazicivo(at)ttnet(dot)net(dot)tr
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PL Caching in TopTransactionContext
Date: 2006-10-05 13:46:47
Message-ID: 12475.1160056007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

<yazicivo(at)ttnet(dot)net(dot)tr> writes:
> I've been planning to implement a caching mechanism for non-volatile
> (and non-SRF) procedures in PL/scheme, that'll return pre-computed
> values in case of a procedure signature overlap[1].

This has generally been considered a bad idea even if implemented for
all function types. It seems even less sane to implement it on a retail
PL-by-PL basis.

> And after reading backend/utils/mmgr/README, I think
> TopTransactionContext is the way for me to go.

You realize that that goes away at the end of each transaction?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-10-05 14:16:34 Re: PL/pgSQL Todo, better information in errcontext from plpgsql
Previous Message Michael Meskes 2006-10-05 12:52:34 Re: pgindent has been run