Re: Custom cache implemented in a postgresql C function - Mailing list pgsql-general

From Tom Lane
Subject Re: Custom cache implemented in a postgresql C function
Date
Msg-id 23525.1287672516@sss.pgh.pa.us
Whole thread Raw
In response to Re: Custom cache implemented in a postgresql C function  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
Alban Hertroys <dalroi@solfertje.student.utwente.nl> writes:
> That sounds like your function would classify as a STABLE function
> within Postgres, did you define it as such? Postgres will cache the
> results of STABLE (and IMMUTABLE) functions all by itself, in which
> case you may not need your custom cache.

Uh, no it won't.  It will pre-evaluate immutable functions that are
called with constant arguments, which is not the same thing at all.

            regards, tom lane

pgsql-general by date:

Previous
From: Aljoša Mohorović
Date:
Subject: Re: postgres services on amazon
Next
From: Tom Lane
Date:
Subject: Re: full vacuum cancelation