Re: Clearing plans

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

> 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.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Garth Keesler 2007-01-19 20:09:01 Re: Multiple column indexes
Previous Message Merlin Moncure 2007-01-19 19:53:45 Re: Multiple column indexes