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