From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Stored procedure returning row or resultset
Date: Tue, 15 Oct 2002 09:57:59 -0400
Message-ID: <14590.1034690279@sss.pgh.pa.us> (raw)
In-Reply-To: <200210150917.26662.dev@archonet.com>
References: <200210141622.54638.heiko.stoermer@login-solutions.de>
<200210141605.04208.dev@archonet.com>
<17131.1034615852@sss.pgh.pa.us>
<200210150917.26662.dev@archonet.com>
Richard Huxton <dev@archonet.com> writes:
> On Monday 14 Oct 2002 6:17 pm, Tom Lane wrote:
>> Unfortunately that's not true at all, or at least not helpful for this
>> problem. The cachable attribute was poorly named, because it leads
>> people to think that PG *will* cache function results, as opposed to
>> *could* cache function results.
> I must admit, that was my impression. Are there simple rules for if/when PG
> will cache function results?
It won't; there is no function cache. What there is is a pass of
constant-folding before a query is run. For example, if you write
select * from foo where x > sqrt(4);
then the function call "sqrt(4)" will be folded down to a constant "2"
before planning and execution starts, rather than evaluating it again
at each row of foo. (This also improves the system's ability to use
indexes, etc, so it's a pretty essential thing.)
The point of the poorly-named isCachable attribute is to tell the
constant-folding pass whether it's safe to apply the function in
advance of execution --- ie, does it always return the same output,
given constant inputs? An example of a non-cachable function is
now().
In 7.3 isCachable has been split into two attributes "immutable"
and "stable", distinguishing functions that are constant for all
time from those whose outputs are constant during any single query.
(sqrt() is immutable, now() is stable, random() is neither.)
These names perhaps will be less likely to mislead people into
thinking that some kind of caching goes on while a query runs.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, dev@archonet.com
Subject: Re: Stored procedure returning row or resultset
In-Reply-To: <14590.1034690279@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox