[Tile-serving] [osm2pgsql] Extremely slow database update (#128)

[kayrus]

I have bare metal with 96Gb RAM, 24 CPU Threads, 2xHDD in RAID0 for Postgres and 1xHDD for flat nodes.

I run osm2pgsql:
```
osm2pgsql -a -s -p planet_osm -U osm -d gis -S /usr/share/osm2pgsql/new.style --cache-strategy dense -C 30000 --number-processes 24 --flat-nodes /data/nodes --hstore -e 9-18 -o expire_list.20140402 554.o5c
```

The result is:
Processing: Node(2101k 3.3k/s) Way(110k 0.13k/s) Relation(0 0.00/s)

While simple planet import gives ~ 900k/s for nodes, 20k/s for ways and 200/s for relations.

Is there a way to increase update performance without SSD?

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