[postgis-users] looking for some perf data

raphael Jacquot sxpert at sxpert.org
Tue Nov 21 09:21:07 PST 2006


Martin Davis wrote:
> 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?

ask my boss :D

> 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
> 




More information about the postgis-users mailing list