Hello, how much time does an import of the whole OSM planet into a PostgreSQL/PostGIS database, including bbox and linestrings, require on modern hardware?
Osmosis seems to get stuck at computing bounding boxes, i.e. this query: UPDATE ways SET bbox = (SELECT Envelope(Collect(geom)) FROM nodes JOIN way_nodes ON way_nodes.node_id = nodes.id WHERE way_nodes.way_id = ways.id) How long will this query take? Is there a way to monitor its progress? Why isn't the content of the column just copied in instead of recomputing everything from scratch? Kind regards, Jens -- Dipl. Inf. Jens Lehmann Department of Computer Science, University of Leipzig Homepage: http://www.jens-lehmann.org GPG Key: http://jens-lehmann.org/jens_lehmann.asc _______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
