[osmosis-dev] osmosis, pgsimpl, bbox

[Jörg Frings-Fürst]

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?



Thanks

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3707 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20130909/b161592e/attachment.bin>