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-18 18:41:01
Message-ID: Pine.GSO.4.33.0104182139140.13885-100000@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jeff,

I checked the archive and it works with 7.1 release
we've implemented only several functions for box, so you may use
them as example for remaining types.

Regards,
Oleg
On Wed, 18 Apr 2001, Oleg Bartunov wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>

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

Browse pgsql-sql by date

  From Date Subject
Next Message Clayton Cottingham aka drfrog 2001-04-18 19:00:24 Re: any proper benchmark scripts?
Previous Message Tom Lane 2001-04-18 18:33:14 Re: Subqueries in select clause