Skip site navigation (1) Skip section navigation (2)

Indexing for geographic objects?

From: Franck Martin <franck(at)sopac(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Indexing for geographic objects?
Date: 2000-11-24 21:43:16
Message-ID: 3A1EE0F4.3DC4161B@sopac.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
I'm building a new geo type and would like to index it. I have heard about
RTREE and boundary box but I'm clueless for the moment about the
implementation....

I have tried to look into PG source code to find the location where the
indexing is done of current line object is done, but couldn't pin point where
is the code and how it works.

I would greatly appreciate if someone could guide me through the methodology to
build an index for a custom type or point me to some readings where the
algorithm is explained (web, book, etc...). I plan to use 3D geographical
objects...

Take this request as a newbie request, because I have never done database
indexing, not because I haven't done programming.

Please reply directly to my e-mail address
Thanks a lot.

franck(at)sopac(dot)org


In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2000-11-24 22:13:44
Subject: Re: OK, that's one LOCALE bug report too many...
Previous:From: Tom LaneDate: 2000-11-24 21:20:27
Subject: OK, that's one LOCALE bug report too many...

pgsql-general by date

Next:From: Peter EisentrautDate: 2000-11-24 22:16:36
Subject: Re: make check and make installcheck
Previous:From: Roberto MelloDate: 2000-11-24 20:28:10
Subject: Re: [SQL] OpenACS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group