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.
Can anyone say whether this is a supported feature in plpgsql, and is
safe to use? Is it simply undocumented, or am I just looking in the
(to reduce ambiguity, the manner in which I'm using this is:
CREATE FUNCTION getconstant(VARCHAR)
IF $1 = ''phrase'' THEN
' LANGUAGE 'plpgsql' WITH (iscacheable);
pgsql-performance by date
|Next:||From: Stephan Szabo||Date: 2004-02-20 15:47:33|
|Subject: Re: cacheable stored functions?|
|Previous:||From: ohp||Date: 2004-02-20 14:51:00|
|Subject: Re: Slow in morning hours|