Am 16.05.2010 00:53, schrieb Peter Körner:
16.05.2010 00:12, schrieb Kai Krueger:
There does seem to be another option that is much
faster:
osm_mapnik=> EXPLAIN ANALYZE select count(*) from planet_point where
(tags @> 'amenity=>baby_hatch');
Oh whow, that's cool!
That's amasing! even a query for "all restaurants in the whole world"
(111746 rows) takes just 3 seconds:
select name from planet_point where (tags @> 'amenity=>restaurant');
That's really nice!
Peter