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

[ekr3peeK]

Some additional data from a program called perpeton:

Basic
		CPU Usage	
34.41 %
		IOWait	
2.72 %
		Load	
2.37
		Memory Usage	
76.62 %
	Apache
		CPU Usage	
0 %
		Memory Usage	
0.01 %
		Disk Read	
4 KBytes
		Disk Write	
8 KBytes
		Web Requests	
0
		Outgoing Traffic	
0 Bytes
	Disk I/O - sda
		Read	
885.56 MBytes
		Write	
1.52 GBytes
		Activity	
36.15 %
	Disk I/O - sda1
		Activity	
0 %
	Disk I/O - sda2
		Activity	
35.83 %
	Disk I/O - sdb
		Read	
0 Bytes
		Write	
0 Bytes
		Activity	
0 %
	Disk Usage - /
		Usage	
7.95 %
	MySQL
		CPU Usage	
0.01 %
		Memory Usage	
0.07 %
	PostgreSQL
		CPU Usage	
4.88 %
		Memory Usage	
5.53 %
		Active Connections	
5
		Disk Read	
13.27 MBytes
		Disk Write	
404.45 MBytes
		Autovacuum Disk Read	
0 Bytes
		Autovacuum Disk Write	
0 Bytes
		Autovacuum Processes	
0
		Pagefault Ratio	
5.52 %
	Swap
		Usage	
2.69 %
		Used Space	
217.32 MBytes

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