User:T-i/Hetzner EX 4

Mein Server

Hetzner EX 4

• Prozessor: Intel Core i7-2600 Quad-Core
• Arbeitsspeicher: 16 GB DDR3 RAM
• Festplatten 2 x 3 TB SATA 6 Gb/s HDD 7200 rpm (Software-RAID 1)

Konfiguration

Ubuntu tile server von Kai Krüger

postgres 9.1

• shared_buffers=768MB
• maintenance_work_mem=6GB
• effective_io_concurrency=2 (bei RAID1)
• fsync=off
• synchronous_commit=off
• full_page_writes=off
• checkpoint_segments=10
• checkpoint_completion_target=0.9
• effective_cache_size=6GB
• autovacuum=off

Statistiken

Planet Import 2011-11-30

osm2pgsql --slim --hstore -C 12000 planet-111130.osm.pbf

• Node stats: total(1280186832), max(1524143108) in 4431s (288.9k/s)
• Way stats: total(116093121), max(139038379) in 4034s (28.78k/s)
• Relation stats: total(1193181), max(1870716) in 28896s (41.29/s)

• Pending ways took 16795s at a rate of 3801.37/s
• Pending relations took 2s at a rate of 0.00/s

• Stopped table: planet_osm_nodes in 0s
• Stopped table: planet_osm_rels in 125s
• Indexes on planet_osm_roads created in 15674s
• Indexes on planet_osm_point created in 17645s
• Indexes on planet_osm_line created in 65731s
• Stopped table: planet_osm_ways in 65926s
• Indexes on planet_osm_polygon created in 67155s
• Osm2pgsql took 121365s overall (~33.75h)

Planet Import 2012-08-01

osm2pgsql --slim --hstore -C 12000 planet-120801.osm.pbf

• Node stats: total(1517336218), max(1847295962) in 4887s (310k/s)
• Way stats: total(143432273), max(173988822) in 8309s (17k/s)
• Relation stats: total(1486052), max(2323594) in 49411s (30/s)

• 83063041 Pending ways took 49888s at a rate of 1664.99/s
• 0 Pending relations took 1s at a rate of 0.00/s

• node cache: stored: 1517336218(100.00%), storage efficiency: 88.78% (dense blocks: 1457699, sparse nodes: 144250184), hit rate: 100.00%

• Stopped table: planet_osm_nodes in 0s
• Stopped table: planet_osm_rels in 100s
• Indexes on planet_osm_roads created in 18224s
• Indexes on planet_osm_point created in 24494s
• Indexes on planet_osm_line created in 79978s
• Indexes on planet_osm_polygon created in 88377s
• Stopped table: planet_osm_ways in 94771s
• Osm2pgsql took 207460s overall (~57.6h)

Munin

Munin