Re: [Fwd: Re: Functionscan estimates]

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [Fwd: Re: Functionscan estimates]
Дата
Msg-id 20050414185809.GD28198@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: [Fwd: Re: Functionscan estimates]  (elein@varlena.com (elein))
Ответы Re: [Fwd: Re: Functionscan estimates]  (elein@varlena.com (elein))
Список pgsql-performance
On Thu, Apr 14, 2005 at 10:39:03AM -0700, elein wrote:

> All functions could have a cost associated with them, set by the writer of
> the function in order for the planner to reorder function calls.
> The stonebraker airplane level example was:
>     select ... from ... where f(id) = 3 and expensive_image_function(img)
> The idea, of course is to weight the expensive function so it was
> pushed to the end of the execution.

So there was only a constant cost associated with the function?  No
estimator function, for example?

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"If you have nothing to say, maybe you need just the right tool to help you
not say it."                   (New York Times, about Microsoft PowerPoint)

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

Предыдущее
От: "Dave Held"
Дата:
Сообщение: Re: How to improve db performance with $7K?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: How to improve db performance with $7K?