Indexing for geographic objects? - Mailing list pgsql-hackers

From Franck Martin
Subject Indexing for geographic objects?
Date
Msg-id 3A1EE0F4.3DC4161B@sopac.org
Whole thread Raw
In response to RE: [GENERAL] PHPBuilder article -- Postgres vs MySQL  ("Robert D. Nelson" <RDNELSON@co.centre.pa.us>)
Responses Re: Indexing for geographic objects?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-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@sopac.org


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: syslog output from explain looks weird...
Next
From: Andrew Bartlett
Date:
Subject: Re: SECURITY: psql allows symlink games in /tmp