[OSM-dev] Hstore revolution
Peter Körner
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.
Peter
More information about the dev
mailing list