User:T-i/Hetzner EX 4S

From OpenStreetMap Wiki
Jump to: navigation, search
  • Reading in file: /home/thomas/OSM/extracts/planet-latest.osm.pbf
  • Processing: Node(1542670k 350.0k/s) Way(146203k 39.60k/s) Relation(537900 64.40/s)
  • Standard exception processing way_id 1082366: TopologyException: side location conflict at 822832 8.30585e+06
  • Processing: Node(1542670k 350.0k/s) Way(146203k 39.60k/s) Relation(972220 72.56/s)
  • Standard exception processing way_id 1670530: TopologyException: side location conflict at 1.87097e+06 5.88368e+06
  • Processing: Node(1542670k 350.0k/s) Way(146203k 39.60k/s) Relation(980730 72.73/s)
  • Standard exception processing way_id 1683435: TopologyException: side location conflict at -8.01753e+06 -4.82195e+06
  • Processing: Node(1542670k 350.0k/s) Way(146203k 39.60k/s) Relation(1518310 77.26/s) parse time: 27751s
  • Node stats: total(1542670142), max(1877473101) in 4407s
  • Way stats: total(146203279), max(177294276) in 3692s
  • Relation stats: total(1518319), max(2368467) in 19652s
  • Committing transaction for planet_osm_point
  • Committing transaction for planet_osm_line
  • Committing transaction for planet_osm_polygon
  • Committing transaction for planet_osm_roads
  • 84599568 Pending ways took 9823s at a rate of 8612.40/s
  • node cache: stored: 1542670142(100.00%), storage efficiency: 88.79% (dense blocks: 1481809, sparse nodes: 146705016), hit rate: 100.00%


  • Stopped table: planet_osm_nodes in 0s
  • Stopped table: planet_osm_rels in 678s
  • All indexes on planet_osm_roads created in 4110s
  • All indexes on planet_osm_point created in 5013s
  • All indexes on planet_osm_line created in 17945s
  • All indexes on planet_osm_polygon created in 20298s
  • Stopped table: planet_osm_ways in 45443s
  • Osm2pgsql took 83030s overall

Import 2012-10-03

  • osm2pgsql SVN version 0.81.0 (64bit id space)
  • Reading in file: /home/thomas/OSM/extracts/planet-latest.osm.pbf
  • Processing: Node(1587893k 318.1k/s) Way(150708k 37.95k/s) Relation(966630 47.35/s)
  • Standard exception processing way_id 1670530: TopologyException: side location conflict at 1.87097e+06 5.88368e+06
  • Processing: Node(1587893k 318.1k/s) Way(150708k 37.95k/s) Relation(975110 47.46/s)
  • Standard exception processing way_id 1683435: TopologyException: side location conflict at -8.01753e+06 -4.82195e+06
  • Processing: Node(1587893k 318.1k/s) Way(150708k 37.95k/s) Relation(1567480 51.43/s) parse time: 39438s
  • Node stats: total(1587893247), max(1933037961) in 4992s
  • Way stats: total(150708533), max(182950438) in 3971s
  • Relation stats: total(1567489), max(2435742) in 30475s
  • Committing transaction for planet_osm_point
  • Committing transaction for planet_osm_line
  • Committing transaction for planet_osm_polygon
  • Committing transaction for planet_osm_roads
  • Going over pending ways...
  • 87617570 ways are pending
  • Using 6 helper-processes
  • Process 3 finished processing 14602928 ways in 6978 sec
  • Process 0 finished processing 14602929 ways in 6978 sec
  • Process 4 finished processing 14602928 ways in 6978 sec
  • Process 5 finished processing 14602928 ways in 6978 sec
  • Process 2 finished processing 14602928 ways in 6978 sec
  • Process 1 finished processing 14602929 ways in 6978 sec
  • All child processes exited
  • 87617570 Pending ways took 6982s at a rate of 12549.06/s
  • Committing transaction for planet_osm_point
  • Committing transaction for planet_osm_line
  • Committing transaction for planet_osm_polygon
  • Committing transaction for planet_osm_roads
  • Going over pending relations...
  • 0 relations are pending
  • Using 6 helper-processes
  • Process 0 finished processing 0 relations in 2 sec
  • Process 1 finished processing 0 relations in 4 sec
  • Process 2 finished processing 0 relations in 4 sec
  • Process 4 finished processing 0 relations in 4 sec
  • Process 5 finished processing 0 relations in 4 sec
  • Process 3 finished processing 0 relations in 4 sec
  • All child processes exited
  • 0 Pending relations took 5s at a rate of 0.00/s
  • Sorting data and creating indexes for planet_osm_point
  • Sorting data and creating indexes for planet_osm_polygon
  • Sorting data and creating indexes for planet_osm_line
  • Sorting data and creating indexes for planet_osm_roads
  • node cache: stored: 1587893247(100.00%), storage efficiency: 86.50% (dense blocks: 1681859, sparse nodes: 56699686), hit rate: 100.00%
  • Stopping table: planet_osm_nodes
  • Stopped table: planet_osm_nodes in 0s
  • Stopping table: planet_osm_ways
  • Stopping table: planet_osm_rels
  • Building index on table: planet_osm_ways (fastupdate=off)
  • Building index on table: planet_osm_rels (fastupdate=off)
  • Stopped table: planet_osm_rels in 68s
  • Analyzing planet_osm_roads finished
  • Analyzing planet_osm_line finished
  • Analyzing planet_osm_point finished
  • Analyzing planet_osm_polygon finished
  • Copying planet_osm_roads to cluster by geometry finished
  • Copying planet_osm_point to cluster by geometry finished
  • Creating indexes on planet_osm_roads finished
  • All indexes on planet_osm_roads created in 12649s
  • Completed planet_osm_roads
  • Creating indexes on planet_osm_point finished
  • All indexes on planet_osm_point created in 15012s
  • Completed planet_osm_point