Re: Optimize expresiions.

From: han(dot)holl(at)informationslogik(dot)nl
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimize expresiions.
Date: 2007-01-12 11:18:17
Message-ID: 200701121218.17585.han.holl@informationslogik.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message han.holl 2007-01-12 11:20:04 Re: Optimize expresiions.
Previous Message Richard Huxton 2007-01-12 11:01:30 Re: Need setup help for Postgresql 8.1.3 on Solaris 10