Hi Paul,
Am Montag, den 09.09.2013, 00:59 -0700 schrieb Paul Norman: > > From: Jörg Frings-Fürst [mailto:o...@jff-webhosting.net] > > Sent: Monday, September 09, 2013 12:47 AM > > To: osmosis-dev@openstreetmap.org > > Subject: [osmosis-dev] osmosis, pgsimpl, bbox > > > > Hi, > > > > on import the planet into pgsimple with action, bbox and linestring > > osmosis is running since 2013-08-31 13:09:41.79458+02 on this part: > > > > UPDATE ways SET bbox = (SELECT ST_Envelope(ST_Collect(geom)) FROM nodes > > JOIN way_nodes ON way_nodes.node_id = nodes.id WHERE way_nodes.way_id = > > ways.id) > > > > > > I think that's a little too long > > > > Any hints? > > Yes. You're trying to build geometries with SQL which is slower than > having osmosis build them. What was your exact osmosis command line? > my command line was: export JAVACMD_OPTIONS="-server -Xmx26G -Djava.io.tmpdir=/db/tmp/" ${OSMOSIS} --read-pbf file=/db/pbf/planet.pbf --ws authFile=${AUTHF} > I also suspect the table needs an ANALYZE and it's running a horrible query > plan so it's taking even longer. > ok. > You appear to be using the load script so you need an ANALYZE before > https://github.com/brettch/osmosis/blob/master/package/script/pgsimple_load_0.6.sql#L48 > or it may try to use sequential scans for each way. > > Even if you fix that, just have osmosis build the geometries and > comment out what you need to in the SQL file. > Jörg -- Jörg Frings-Fürst OSM privat D-54526 Landscheid GPG Fingerprint: 13E3 4D4A 3228 D138 8511 EA5A 08AC AF02 3C6D 750A Full GPG key: hkp://pool.sks-keyservers.net CAcert Serialnr.: 0D:9A:23 SHA1-Fingerprint: CA:36:4D:44:D1:71:4A:78:C8:6C:C2:CC:94:F3:6E:42:38:BA:CE:4E http://cacert.org
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev