Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)

Поиск
Список
Период
Сортировка
От Mischa
Тема Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
Дата
Msg-id 1112909198.4255a58eae0d8@webmail.telus.net
обсуждение исходный текст
Ответ на Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> Yeah, the whole thing is only a heuristic anyway.  I've been coming
> around to the view that relation membership shouldn't matter, because
> of cases like
>
>     WHERE a.x > b.y AND a.x < 42
>
> which surely should be taken as a range constraint.

Out of curiosity, will the planner induce "b.y < 42" out of this?

--
"Dreams come true, not free."

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

Предыдущее
От: Adam Palmblad
Дата:
Сообщение: Re: Building postmaster with Profiling Support WAS "Tweaking a C
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)