Re: point_ops for GiST

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: point_ops for GiST
Дата
Msg-id 20150512181307.GJ2523@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: point_ops for GiST  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: point_ops for GiST  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: point_ops for GiST  (Emre Hasegeli <emre@hasegeli.com>)
Re: point_ops for GiST  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Список pgsql-hackers
Robert Haas wrote:
> 2009/12/30 Teodor Sigaev <teodor@sigaev.ru>:
> > Sync with current CVS
> 
> I have reviewed this patch and it looks good to me.  The only
> substantive question I have is why gist_point_consistent() uses a
> different coding pattern for the box case than it does for the polygon
> and circle cases?  It's not obvious to me on the face of it why these
> aren't consistent.

Emre Hasegeli just pointed out to me that this patch introduced
box_contain_pt() and in doing so used straight C comparison (<= etc)
instead of FPlt() and friends.  I would think that that's a bug and
needs to be changed -- but certainly not backpatched, because gist
indexes would/might become corrupt.

This is in the context of his inclusion opclass for BRIN
http://www.postgresql.org/message-id/CAE2gYzwBZQ=z02ZiOefNhrXOf+1VegQC_cWPVJ8LwNqGX1--Ww@mail.gmail.com

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Multi-xacts and our process problem
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: point_ops for GiST