Re: Suggestions please: names for function cachabilityattributes
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: mlw <markw@mohawksoft.com>, pgsql-hackers@postgresql.org
Date: 2002-04-03T18:29:40Z
Lists: pgsql-hackers
It occurs to me that we also need a better term for the overall concept. "cacheability" has misled at least two people (that I can recall) into thinking that we maintain some kind of function result cache --- which is not true, and if it were true we'd need the term "cacheable" for control parameters for the cache, which this categorization is not. I am thinking that "mutability" might be a good starting point instead of "cacheability". This leads immediately to what seems like a fairly reasonable set of names: pg_proc column: promutable or proismutable case 1: "immutable" case 2: "mutable", or perhaps "stable" case 3: "volatile" Thoughts? regards, tom lane