User:T-i/Hetzner EX 4

From OpenStreetMap Wiki
Jump to: navigation, search

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