Richard Huxton wrote:
> On Friday 20 February 2004 15:35, Bill Moran wrote:
>>I'm converting a SQL application to PostgreSQL. The majority of the logic
>>in this application is in the stored functions in the database.
>>Somewhere, I saw a reference to "WITH (iscachable)" for stored functions,
>>looking again, I'm unable to find any reference to this directive. I have
>>a single function that is _obviously_ safe to cache using this, and it
>>generates no errors or problems that I can see.
>>Now I'm looking at a lot of other functions that, if cached, would speed
>>up performance considerably. Yet I'm reluctant to use this directive
>>since I can't find documentation on it anywhere.
>>From memory, "iscachable" was replaced in version 7.3 by the three
> finer-grained settings IMMUTABLE, STABLE, VOLATILE.
> I'm guessing the old behaviour is still there for backwards compatibility, but
> it's probably best to use the new versions.
Thanks to everyone who replied (with more or less the same answer ;)
This has explained away my confusion, and I now have a reference to read.
In response to
pgsql-performance by date
|Next:||From: Sean Shanny||Date: 2004-02-20 19:17:10|
|Subject: General performance questions about postgres on Apple hardware...|
|Previous:||From: Richard Huxton||Date: 2004-02-20 16:01:28|
|Subject: Re: cacheable stored functions?|