Re: Optimize expresiions.

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: Optimize expresiions.
Дата
Msg-id 45A645D0.50701@magproductions.nl
обсуждение исходный текст
Ответ на Re: Optimize expresiions.  (han.holl@informationslogik.nl)
Ответы Re: Optimize expresiions.
Список pgsql-general
han.holl@informationslogik.nl wrote:
> On Thursday 11 January 2007 12:34, Richard Huxton wrote:
>
>>> The query would run much faster with the filter reordered.
>>> Is there a way to tell the planner/optimizer that certain functions are
>>> more expensive than others, and should be postponed in lazy evaluation ?
>>> Or is there a hook in the system that would allow me too look at and
>>> maybe reorder expressions before they are executed ?
>> Not really. Perhaps look into using a functional/expressional index and
>> see if that does the job for you.
>>
> Oh well, pity. Thanks anyway.
> In my case, indexes don't help.

Maybe your functions can be marked STABLE or even IMMUTABLE? That should
help the planner evaluate them less often.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

В списке pgsql-general по дате отправления:

Предыдущее
От: "Jeanna Geier"
Дата:
Сообщение: Re: Problems With VIEWS
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Problems With VIEWS