[osmosis-dev] osmosis, pgsimpl, bbox

Jörg Frings-Fürst osm at jff-webhosting.net
Mon Sep 9 12:45:02 UTC 2013


Hi Paul,

Am Montag, den 09.09.2013, 00:59 -0700 schrieb Paul Norman:
> > From: Jörg Frings-Fürst [mailto:osm at jff-webhosting.net]
> > Sent: Monday, September 09, 2013 12:47 AM
> > To: osmosis-dev at openstreetmap.org
> > Subject: [osmosis-dev] osmosis, pgsimpl, bbox
> > 
> > Hi,
> > 
[...]
> 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.

Some Questions:

When I stop osmosis now and run ANALYSE can I then run
pgsimple_load_0.6.sql from line 42 to end?


Or must I copy the data to *.txt, truncate the db  and run the
completely script?

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/5ae28569/attachment.bin>


More information about the osmosis-dev mailing list