Re: RTREE on points

GiST is great !

You may look at http://www.sai.msu.su/~megera/postgres/gist/
for GiST implementation of RTree - it could be not compiled with 7.1
release due to some api changes, but it's not difficult to do.
If somebody want it I could contribute it to contrib area.

Tom,
what we need to do to improve GiST support is to provide selectivity
information of gist indices to optimizer. I'll post separate message
about this problem

Oleg
On Tue, 17 Apr 2001, Jeff Hoffmann wrote:

> 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.
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83