[Talk-us] tools for analysis of road networks?

Martijn van Exel m at rtijn.org
Wed Dec 5 18:23:25 GMT 2012


Interesting, I have been looking for a way to speed up those types of
queries for a while, thanks!

Do you have metrics on this?

On Wed, Dec 5, 2012 at 10:53 AM, Paul Norman <penorman at mac.com> wrote:

> Something else is that tags->'highway' in ( 'motorway', 'primary',
> 'secondary' ) will NOT use indexes on tags.****
>
> ** **
>
> tags @> hstore('highway', 'motorway') OR tags @> hstore('highway',
> 'primary') OR tags @> hstore('highway', 'secondary') should be
> significantly faster with proper indexes.****
>
>


-- 
Martijn van Exel
http://oegeo.wordpress.com/
http://openstreetmap.us/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-us/attachments/20121205/40eed38a/attachment.html>


More information about the Talk-us mailing list