[OSM-dev] Adding a table to osm2pgsql (and a couple utility patches) [patch]

[Phil! Gold]

* Frederik Ramm <frederik at remote.org> [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
---- --- --