[OSM-dev] Hstore revolution

[Peter Körner]

Am 18.05.2010 23:19, schrieb Sven Geggus:
> As far as Database queries are concerned one should use something
> like this for performance reasons:
>
> select ... from planet_osm_point where (tags @>  'amenity=>fire_station');
>
> rather than
>
> select ... from planet_osm_point where (tags->'amenity' = 'fire_station');
>
> Which is quite slow.

This is true with a GIN index on the tags column.

Peter