Re: Index scan troubles

Поиск
Список
Период
Сортировка
От Markus Wanner
Тема Re: Index scan troubles
Дата
Msg-id 48BD8CA2.7050204@bluegap.ch
обсуждение исходный текст
Ответ на Re: Index scan troubles  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Hi,

Gregory Stark wrote:
> It's right for your equality case which is effectively x=const, y=const,
> z=const. It's not for row comparisons case for which you need a funny "header"
> ScanKey. See the comments in access/skey.h, search for "row comparisons". I'm
> not sure if there's a function to create this for you or if you have to do it
> yourself. Search for other places where SK_ROW_HEADER appears.

Ah, so the default for multiple ScanKeys is 'x > const AND y > const' 
and not the row comparison. That explains my troubles. Thanks a lot.

Regards

Markus Wanner



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: WIP patch: Collation support
Следующее
От: Tom Lane
Дата:
Сообщение: Re: WIP patch: Collation support