Re: KNN-GiST with recheck

Поиск
Список
Период
Сортировка
От Emre Hasegeli
Тема Re: KNN-GiST with recheck
Дата
Msg-id 20140917081250.GA28651@hasegeli.com
обсуждение исходный текст
Ответ на Re: KNN-GiST with recheck  (Alexander Korotkov <aekorotkov@gmail.com>)
Ответы Re: KNN-GiST with recheck  (Emre Hasegeli <emre@hasegeli.com>)
Список pgsql-hackers
> > While looking it at I found a bug.  It returns the second column
> > in wrong order when both of the distance functions return recheck = true.
> > Test script attached to run on the regression database.  I tried to
> > fix but could not.  searchTreeItemDistanceRecheck function is not
> > very easy to follow.  I think it deserves more comments.
>
> Fixed, thanks. It was logical error in comparison function implementation.

I managed to break it again by ordering rows only by the second column
of the index.  Test script attached.

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: jsonb format is pessimal for toast compression
Следующее
От: Emre Hasegeli
Дата:
Сообщение: Re: KNN-GiST with recheck