[osmosis-dev] planet import time

[Frederik Ramm]

Jens,

Jens Lehmann wrote:
> 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?

Well you have to compute it somewhere because it is not in the planet. 
But you can use the osmosis --wp option enableBboxBuilder to have the 
boox built in Java and then copied into PostGIS rather than having it 
built in PostGIS. Doing it in Java is faster but I don't know by how 
much. See 
http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage#--write-pgsql_.28--wp.29

Bye
Frederik