[OSM-dev] By the way ... spatial indexes

Andreas Kalsch andreaskalsch at gmx.de
Mon Sep 29 14:50:34 BST 2008


... are nearly 4 times faster than multi.colum indices for lat/lon in 
MySQL. Extracting 1 column / 17.000 rows out of 1 million takes .39 secs 
vs. 1.39 - I think all Postgres guys know a similar value. I think this 
is a pretty impressing result.






More information about the dev mailing list