User:T-i/Hetzner EX 4

Contents 1 Mein Server 2 Konfiguration: 2.1 postgres 9.1: 3 Statistiken 3.1 Planet Import 3.2 Munin

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

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)

Munin

Munin