Re: Stored procedure returning row or resultset

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Stored procedure returning row or resultset
Date: 2002-10-15 08:17:26
Message-ID: 200210150917.26662.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Monday 14 Oct 2002 6:17 pm, Tom Lane wrote:
> Richard Huxton <dev(at)archonet(dot)com> writes:
> > Have you looked at marking f1() etc cachable? This means Postgresql
> > will only call the function once for each parameter-set.
>
> 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?

--
Richard Huxton

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2002-10-15 08:23:15 Re: Slow performance on MAX(primary_key)
Previous Message Keith Gray 2002-10-15 07:47:13 Re: Slow performance on MAX(primary_key)