[Tile-serving] [osm2pgsql] Extreme slowdown while importing ways (#534)

[ekr3peeK]

While trying to import a planet PBF file, on a 16 GB ram, 8 core system, with non-SSD hard drives, when I reach to the part of importing ways, I run into an extreme slowdown. While the nodes are importing with a ~1500k/s speed, the ways are only importing with 0.05k/s-0.12k/s (ocassionaly rising up to 0.44k/s, but then dropping down immediatly).

I am using the following parameters to run the script: -lsc -O gazetteer --hstore --number-processes 6 --slim -s -C 12000 --flat-nodes <filename> (I am running osm2pgsql through the Nominatim setup.php file, and modified some data in it, for experimenting, but nothing seems to help to speed up the import of ways)

Browsing through the internet, other people experienced this same problem, but I couldn't find any solution to it. What could cause this error? What other options could I try?

(For a detailed description to my problem, I've also posted to StackOverflow, and OSM Help, but no answer arrived there, here's a link: http://stackoverflow.com/questions/35632180/osm2pgsql-importing-of-an-openstreetmaps-planet-file-takes-very-long )

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/534
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20160226/5b1ef01e/attachment.html>