[OSM-dev] Towards spatial indexing (was: OSM the mediocre alternative)

Martijn van Oosterhout kleptog at gmail.com
Sun Apr 22 13:46:15 BST 2007


On 4/22/07, A Morris <aledmorris2 at gmail.com> wrote:
>  I would like to do some doing, rather than just talking (actually mostly
> reading). So... what I propose to do is to create a test suite that stresses
> the database, simulating current and future loads, to enable us to find the
> best solution to the spatial indexing problem. (Possibly in the future, it
> might help in fixing the data model problems also)

Go for it. MySQL has some spatial support, and postgresql has
extensive support for spatial types. I've even played with some custom
index types in PostgreSQL to see if they might be useful. But if you
want to do testing to find how much of an improvement is possible, go
for it.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/




More information about the dev mailing list