* Frederik Ramm <[email protected]> [2011-01-18 21:01 +0100]: > Would the planet_osm_rels table that is produced in --slim mode not > have been suitable?
I tried using that table, but JOINs into the parts array were unacceptably slow, presumably because there was no index available for it. It's also not easy to use the planet_osm_rels table if you want to filter on roles or member types. > Or asking this another way round, if I am using --slim mode can I now > drop planet_osm_rels and use your table instead? Possibly, although I haven't familiarized myself with the middle-pgsql portion of osm2pgsql. My implementation doesn't store the relation's tags, for one thing; I plan on retrieving those from the planet_osm_line table for rendering purposes. When I get a chance (possibly not for a few days), I'll look at the middle layer and see if I can tell what it would take to use this table in both phases. -- ...computer contrarian of the first order... / http://aperiodic.net/phil/ PGP: 026A27F2 print: D200 5BDB FC4B B24A 9248 9F7A 4322 2D22 026A 27F2 --- -- I would be content if my children grew up to be the kind of people who think decorating consists mostly of building enough bookshelves. -- Anna Quindlen ---- --- -- _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
