Re: RTREE on points - Mailing list pgsql-sql

From Oleg Bartunov
Subject Re: RTREE on points
Date
Msg-id Pine.GSO.4.33.0104180014220.13885-100000@ra.sai.msu.su
Whole thread Raw
In response to Re: RTREE on points  (Jeff Hoffmann <jeff@propertykey.com>)
Responses Re: RTREE on points
List pgsql-sql
On Tue, 17 Apr 2001, Jeff Hoffmann wrote:

> Oleg Bartunov wrote:
> >
> > 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.
>
> it looks like i just wasted a good couple of hours trying to convert the
> gist_box_ops.  it did help find the pointer problem i was having because
> i'm still not up to speed on the new function calling conventions,
> though...
>

:-)

> > If somebody want it I could contribute it to contrib area.
>
> i'm definitely interested.  i'm going to play with it & if oleg's claim
> holds about index insertion time holds, i can definitely see myself
> moving to it over the built in rtree.  anything that can cut down the
> hours of index creation time would be great.  also, it seems that it'd
> be a good choice for inclusion in the standard distribution because it'd
> be easy to test -- you already have to run rtree tests anyway, you can
> just duplicate them with gist & gist_box_ops.
>

nice you noticed that ! We'll update contrib-rtree_box_gist for 7.1 release
in a few days.

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



pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: is this proper sql?
Next
From: "Diehl, Jeffrey"
Date:
Subject: Problems w/ PL/pgSQL not being loaded?