Re: Clearing plans

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Scott Ribe" <scott_ribe(at)killerbytes(dot)com>
Cc: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Clearing plans
Date: 2007-01-19 20:16:56
Message-ID: b42b73150701191216q30a67106g8122a1eba09b3d74@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/19/07, Scott Ribe <scott_ribe(at)killerbytes(dot)com> wrote:
> > Also, somebody correct me if I'm off my rocker here, but immutable
> > procedures are re-evaluated for each execution...they are just folded
> > into a constant during plan phase.
>
> You would need to actually create an immutable function in order to test how
> immutable functions work ;-) And apparently you can only do that on
> functions that return a value.

d'oh! that was just a transcription error though...if you create f()
returning bigint and immutable it produces the same results.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-01-19 20:20:54 Re: Spam from EnterpriseDB?
Previous Message Karen Hill 2007-01-19 20:12:34 Re: Spam from EnterpriseDB?