Osm2pgsql/benchmarks/Custom server vm import 1

From OpenStreetMap Wiki
Jump to: navigation, search
Node stats: total(1569263893), max(1911061525) in 37890s
Way stats: total(148855135), max(180661392) in 42012s
Relation stats: total(1547449), max(2410292) in 113829s
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

Using 7 helper-processes
WARNING: Failed to fork helper processes. Falling back to only using 1
processing way (86602k) at 0.90k/s
Process 0 finished processing 86602904 ways in 96254 sec

All child processes exited

86602904 Pending ways took 96254s at a rate of 899.73/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

Using 7 helper-processes
WARNING: Failed to fork helper processes. Falling back to only using 1

Process 0 finished processing 0 relations in 2 sec

All child processes exited
0 Pending relations took 2s at a rate of 0.00/s

Sorting data and creating indexes for planet_osm_point
Sorting data and creating indexes for planet_osm_line
Sorting data and creating indexes for planet_osm_polygon
node cache: stored: 1569263893(100.00%), storage efficiency: 86.49% (dense blocks: 1662177, sparse nodes: 56150096), hit rate: 100.00%
Sorting data and creating indexes for planet_osm_roads
Stopping table: planet_osm_nodes
Stopping table: planet_osm_ways
Building index on table: planet_osm_ways (fastupdate=off)
Stopped table: planet_osm_nodes in 0s
Stopping table: planet_osm_rels
Building index on table: planet_osm_rels (fastupdate=off)
Analyzing planet_osm_roads finished
Analyzing planet_osm_point finished
Analyzing planet_osm_line finished
Analyzing planet_osm_polygon finished
Stopped table: planet_osm_rels in 4110s
Copying planet_osm_roads to cluster by geometry finished
Creating indexes on  planet_osm_roads finished
All indexes on  planet_osm_roads created  in 30969s
Completed planet_osm_roads

Copying planet_osm_point to cluster by geometry finished
Creating indexes on  planet_osm_point finished
All indexes on  planet_osm_point created  in 51476s
Completed planet_osm_point
Copying planet_osm_line to cluster by geometry finished
Creating indexes on  planet_osm_line finished
All indexes on  planet_osm_line created  in 242518s
Completed planet_osm_line
Copying planet_osm_polygon to cluster by geometry finished
Creating indexes on  planet_osm_polygon finished
All indexes on  planet_osm_polygon created  in 258138s
Completed planet_osm_polygon
Stopped table: planet_osm_ways in 277108s

Osm2pgsql took 570030s overall