Horton

Re: spatial index

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: James Reid <james.reid@ed.ac.uk>
Cc: pgsql-novice@postgresql.org
Date: 2001-11-29T14:49:10Z
Lists: pgsql-novice 
James Reid <james.reid@ed.ac.uk> writes:
> [ how to do a spatial index ]

Take a look at PostGIS, http://postgis.refractions.net.
Not sure that you want everything in there, but their
approaches to indexing might be useful.

BTW, there are nontrivial bug fixes for both rtree and gist
index types in 7.2, so you might want to run on latest 7.2
beta rather than 7.1.

			regards, tom lane