Re: spatial index

On Thu, 29 Nov 2001, James Reid wrote:

> hi - a very simple question from a newbie. Im tyring to outdo my colleagues Perl code (running on the same machine)
forspatial operations (point-in-poly) but on a vanilla install of postgres 7.1 his perl is 20 times faster!! Ive no
spatialindex built on the polygon but I cant get one built as it complains of a tuple_row error which  i assume relates
tothe use of the default 8Kb block size - my question is - how do I rebuild with a bigger block size so as I can build
anrtree on the poly? (or can someone give me some idea of how postgres spatial operations perform relative to other
solutions- Id like to employ postgres for a gazetteer service but I need to get the speed of response up....any
ideas/thoughtsappreciated) 

[ Sorry, I'm not going to reformat his paragraph. ]
Are you running 7.1?  That gets around some of the tuple size
issues.  There is a Spatial DBase add-on to PostgreSQL
called PostGIS (?).  You might want to look around the
OpenGIS consortium website to get info on this, and other
spatial oriented things.

Gord

Matter Realisations     http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng. President
101  9504 182 St. NW    Edmonton, AB, CA  T5T 3A7
780/481-8019            ghaverla @ freenet.edmonton.ab.ca
780/993-1274 (cell)