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

[SteveC]

Thanks

thank FSM we don't use multi column indexes then huh?

On 29 Sep 2008, at 06:50, Andreas Kalsch wrote:

> ... 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.
>
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>

Best

Steve