On Wed, Dec 5, 2012 at 3:07 PM, Paul Norman <penor...@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/ _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
