[postgis-users] looking for some perf data

[Martin Davis]

Well, those are range queries.  Not too surprising, 99.9% of spatial 
queries are.

The real question is: given that every modern spatial database uses some 
sort of spatial index (R-tree, quad-tree, or grid), why even bother to 
question whether B-trees might be better?

raphael Jacquot wrote:
>
> typically I'm looking to compare using
>
> create table blah1 (
>     lon    double precision,
>     lat    double precision
> )
> with one index on lon and another one on lat
>
> the classic request being
> lon>constant1 and lon<constant2 and lat>constant3 and lat<constant4
>
> and
>
> create table blah2 (
>     position Point
> )
> with a gist r-tree index
>
> using the @ operator

-- 
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022