Re: disable seqscan

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: disable seqscan
Дата
Msg-id 9062FD1C-C911-40D3-A1A3-843B5CCA5C9E@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на Re: disable seqscan  (Nick Raj <nickrajjain@gmail.com>)
Список pgsql-general
On 24 May 2011, at 8:22, Nick Raj wrote:
> One think i am not able to understand is, if i use ndpoint_overlap method it is going for seq. scan every time but if
iuse && operator it is using index scan. Why it is so? 

> Why these is happening?

Tom already explained that, but in short: Because a function is not an operator.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4ddb741511921606159980!



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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: strange behaviour in 9.0.2 / ERROR: 22003: value out of range: overflow
Следующее
От: Trenta sis
Дата:
Сообщение: Re: Postgres questions