[OSM-dev] Hstore revolution
osm-lists at mazdermind.de
Tue May 18 22:28:21 BST 2010
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.
More information about the dev