Osm2pgsql/benchmarks/Custom server vm import 1
< Osm2pgsql | benchmarks
Jump to navigation
Jump to 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