[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