Hello, Frederik Ramm schrieb: > 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.
A solution would be to include it in the planet or provide it as a separate file, which can be loaded into the database. > 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 > Thanks for this hint (and it is somewhat surprising that PostGIS is slower than a Java based solution). Can the long running bbox query be aborted/killed without resulting in a corrupt database or do I have to start the import from scratch for testing the Java based solution? I would still appreciate any hint on how long it actually takes to compute the bounding boxes. If it takes longer than a week on a 16 GB dual core machine, then I could stop the process immediately. 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
