Re: [PATCH] we have added support for box type in SP-GiST index

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: [PATCH] we have added support for box type in SP-GiST index
Дата
Msg-id 56F16DEA.2030905@sigaev.ru
обсуждение исходный текст
Ответ на Re: [PATCH] we have added support for box type in SP-GiST index  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
> Isn't this basically the same thing that the cube contrib module does? (Which
> has the added benefit of kNN-capable operators).
No, cube module introduces new type - N-dimensional box. And adds an index 
support for it.

Current patch suggests non-traditional indexing technique for 2D boxes by 
treating them as point in 4D space. With such representation it's became 
possible to use quad-tree technique which:
1 supports only points to index
2 already supported by SP-GiST

Such technique provides some benefits in comparance with traditional R-Tree 
which implemented in pg with a help GiST. See Oleg's message.


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 



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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: [PATCH] we have added support for box type in SP-GiST index
Следующее
От: David Steele
Дата:
Сообщение: Re: Updated backup APIs for non-exclusive backups