Re: "Constraint exclusion" is not general enough

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: "Constraint exclusion" is not general enough
Дата
Msg-id 1154973425.848.120.camel@home
обсуждение исходный текст
Ответ на Re: "Constraint exclusion" is not general enough  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 2006-08-07 at 13:44 -0400, Tom Lane wrote:
> Rod Taylor <pg@rbt.ca> writes:
> > A simple way of doing this might be to use a minimum cost number?
> 
> But you don't have any cost numbers until after you've done the plan.

Isn't it possible to find the cost using the straight forward (fast)
method, find out what order of magnitude it is in, then do a second pass
with additional planner bells and whistles turned on if the first plan
had a high estimate?

-- 



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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: Another Ltree/GiST problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: buildfarm - make check failures for leveret on 8.0 and 8.1