Re: set the cost of an aggregate function

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: set the cost of an aggregate function
Дата
Msg-id 1259842743.13774.30895.camel@ebony
обсуждение исходный текст
Ответ на Re: set the cost of an aggregate function  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Ответы Re: set the cost of an aggregate function  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Список pgsql-hackers
On Mon, 2009-11-30 at 11:53 -0500, Jaime Casanova wrote:
> 2009/11/30 Jaime Casanova <jcasanov@systemguards.com.ec>:
> > Hi,
> >
> > why we can't do $subject? it could have any benefit on the planner?
> >
> 
> seems like while we can set the cost of the state transition function,
> that cost is not propagated...

The cost of comparison functions is not considered in cost_sort()
either.

The answer is nobody got round to enhancing this yet and well considered
proposals and subsequent patches would be welcome. 

-- Simon Riggs           www.2ndQuadrant.com



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

Предыдущее
От: Laurent Laborde
Дата:
Сообщение: Re: Cost of sort/order by not estimated by the query planner
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [GENERAL] pg_attribute.attnum - wrong column ordinal?