I've got a PostGIS database created and maintained with osm2pgsql. For some of the Mapnik rendering I'm doing, I'd like to see whether ways belong to relations. (Specifically, whether a highway=* way is a member of a route=road relation.) I've been able to look in the planet_osm_rels table for relation membership, but the members are stored in an array, and searching those arrays for membership, even on a bbox-restricted subset, is really slow. Is there any way to do this faster? If not, I suppose I can file a feature request against osm2pgsql for an indexed relation membership table.
-- ...computer contrarian of the first order... / http://aperiodic.net/phil/ PGP: 026A27F2 print: D200 5BDB FC4B B24A 9248 9F7A 4322 2D22 026A 27F2 --- -- Last Rule of Politics: Kingdoms are good. Empires are evil. -- Console Role Playing Game Clichés, item 74 ---- --- -- _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk