Re: RTREE on points

Поиск
Список
Период
Сортировка
От Jeff Hoffmann
Тема Re: RTREE on points
Дата
Msg-id 3ADC7E8F.7569BABD@propertykey.com
обсуждение исходный текст
Ответ на RTREE on points  ("Julian Scarfe" <julian@avbrief.com>)
Ответы Re: RTREE on points  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: RTREE on points  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-sql
Tom Lane wrote:
> 
> I don't recall any such thing having been removed, but it does seem
> peculiar that there are no GIST opclasses in the standard distribution.
> How the heck did the GIST index code get developed/tested without some
> opclasses?

doing some digging at berkeley, i found the original pggist patch file
that created the gist access method & gist_box_ops opclass (among
others).  i'm assuming that patch was the basis for what was originally
introduced, so i don't know why it didn't get included with everything
else.  it looks like there are a lot of calls to internal postgresql box
comparison functions that would need to get converted to the new calling
convention, but it should be pretty straightforward to get it to work
with a recent version of postgresql.   it does seem pretty silly to have
it in there if you don't have any built-in way of using it, if for no
other reason than to be able to test if the feature even works. 

-- 

Jeff Hoffmann
PropertyKey.com


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] drastic reduction in speed of inserts as the table grows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: RTREE on points