Re: RTREE on points

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Jeff Hoffmann <jeff(at)propertykey(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: RTREE on points
Date: 2001-04-17 21:18:14
Message-ID: Pine.GSO.4.33.0104180014220.13885-100000@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Nils Zonneveld 2001-04-17 22:25:31 Re: Same question about PostgreSql
Previous Message Peter Eisentraut 2001-04-17 20:48:55 Re: is this proper sql?