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

Martijn van Exel m at rtijn.org
Wed Dec 5 23:54:41 GMT 2012

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

More information about the dev mailing list