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

[Ian Dees]

These are the sorts of queries that jxapi does all the time.

hstore's @> and ? operators use index, others don't.

As far as metrics... an xapi query like
[highway=*][ref|name=*][bbox=a,b,c,d] on jxapi was taking ~5-10 hours when
it was using "exists(tags, 'highway')" (which doesn't use the index on
hstore) while the exact same xapi query using the "tags ? 'highway'" takes
about 20 minutes.


On Wed, Dec 5, 2012 at 12:23 PM, Martijn van Exel <m at rtijn.org> wrote:

> 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/
>
> _______________________________________________
> Talk-us mailing list
> Talk-us at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-us
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-us/attachments/20121205/8d328f17/attachment.html>