[OSM-dev] osm2pgsql slow slim import

"Petr Morávek [Xificurk]" xificurk at gmail.com
Thu Dec 1 10:13:06 GMT 2011


sly (sylvain letuffe) napsal(a):
> 
>> Can you try if using the switch --number-processes=1? That should disable
>> any parallelisation and make it more or less the same as before. (Although
>> there is a slight difference in transaction handling)
> 
> It's x2 faster with --number-processes=4 instead of 1 but still far from older 
> version

Kai has suggested to me changing configuration of postgresql like this:

fsync = off
synchronous_commit = off

And this worked like a charm, now I'm getting significantly faster
imports compared to old config and old osm2pgsql.

Best regards,
Petr Morávek aka Xificurk

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20111201/53c993e8/attachment.pgp>


More information about the dev mailing list