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

[ekr3peeK]

This is the result bonnie++ gives with the following parameters:
bonnie++ -d /root/test -r 15886 -u root

Version  1.96       ------Sequential Output------ --Sequential Input- --Random-
Concurrency   1     -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP  /sec %CP
myserver.server 31772M   536  98 129442  20 58196   9  2712  98 165346  11 403.6   4
Latency             17336us     238ms    1111ms   16821us     126ms     985ms
Version  1.96       ------Sequential Create------ --------Random Create--------
myserver.server -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
              files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP
                 16 +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++
Latency                97us     543us     457us      90us      15us      67us
1.96,1.96,myserver.server.server,1,1456477892,31772M,,536,98,129442,20,58196,9,2712,98,165346,11,403.6,4,16,,,,,+++++,+++,+++++,+++,+++++,+++,++
+++,+++,+++++,+++,+++++,+++,17336us,238ms,1111ms,16821us,126ms,985ms,97us,543us,457us,90us,15us,67us

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