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

[Martijn van Exel]

On Wed, Dec 5, 2012 at 3:07 PM, Paul Norman <penorman at mac.com> wrote:
[..]
> If there is some hstore value that you use a lot for complicated queries
> where you need to use the -> operator it’s possible to index that
> specifically.

I think you can use btree or hash indexes that support
tag->'key'='value' queries, but I haven't done extensive testing on
that. btree indexes tend to fail because the tag values can be
extremely long  in OSM (I believe they need to be smaller than 1/3 of
the page size for btree to work)

-- 
Martijn van Exel
http://oegeo.wordpress.com/
http://openstreetmap.us/