[OSM-dev] Spatial vs. multi-column indexes for points

[Sascha Silbe]

On Thu, Sep 11, 2008 at 01:49:55PM +0200, Andreas Kalsch wrote:

> Has anybody used GIS successfully in MySQL or PGSQL and can tell me 
> how the performance compares between the two techniques?
At least in PostgreSQL/PostGIS, the geometric indices are WAY faster. 
Just remember to either use the ST_* family of predicates (implicit 
bounding box scan) or add an "&&" term to do an explicit bounding box 
scan so the index is actually used.

CU Sascha

-- 
http://sascha.silbe.org/
http://www.infra-silbe.de/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 481 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20080911/337faeb3/attachment.pgp>