[OSM-dev] Hstore revolution

[Sven Geggus]

Jukka Rahkonen <jukka.rahkonen at latuviitta.fi> wrote:

> Sven Geggus has made a pretty good job with adding this fine
> feature into osm2pgsql.

Thanks. Credits should also go to Jochen Topf for suggesting hstore
as a well suited storage Method for OSM Data in the first place :)

Peter and the the other Wikipedia People are currently running a
hstore enabled Database of the whole Planet featuring minutely
updates. Query-to-map is using this Database since Saturday.

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.

Regards

Sven

-- 
"If you don't make lower-resolution mapping data publicly
available, there will be people with their cars and GPS
devices, driving around with their laptops" (Tim Berners-Lee)
/me is giggls at ircnet, http://sven.gegg.us/ on the Web