Re: Optimize expresiions. - Mailing list pgsql-general

From han.holl@informationslogik.nl
Subject Re: Optimize expresiions.
Date
Msg-id 200701121218.17585.han.holl@informationslogik.nl
Whole thread Raw
In response to Re: Optimize expresiions.  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
On Thursday 11 January 2007 15:12, Alban Hertroys wrote:
> Maybe your functions can be marked STABLE or even IMMUTABLE? That should
> help the planner evaluate them less often.

They are immutable, nevertheless they will have to be computed for each
record. I'd just like to have some influence on the order in case of lazy
evaluation.

Han Holl

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Need setup help for Postgresql 8.1.3 on Solaris 10
Next
From: han.holl@informationslogik.nl
Date:
Subject: Re: Optimize expresiions.