# Osm2pgsql/benchmarks/Custom server vm import 2

From OpenStreetMap Wiki

< Osm2pgsql | benchmarks

Node stats: total(1569263893), max(1911061525) in 34883s Way stats: total(148855135), max(180661392) in 26670s Relation stats: total(1547449), max(2410292) in 62384s Committing transaction for tf_point Committing transaction for tf_line Committing transaction for tf_polygon Committing transaction for tf_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 1.90k/s Process 0 finished processing 86602904 ways in 45681 sec All child processes exited 86602904 Pending ways took 45681s at a rate of 1895.82/s Committing transaction for tf_point Committing transaction for tf_line Committing transaction for tf_polygon Committing transaction for tf_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 1 sec All child processes exited 0 Pending relations took 1s at a rate of 0.00/s Sorting data and creating indexes for tf_point Sorting data and creating indexes for tf_line Sorting data and creating indexes for tf_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 tf_roads Stopping table: tf_nodes Stopping table: tf_ways Stopped table: tf_nodes in 0s Building index on table: tf_ways (fastupdate=off) Stopping table: tf_rels Building index on table: tf_rels (fastupdate=off) Analyzing tf_roads finished Analyzing tf_point finished Analyzing tf_polygon finished Analyzing tf_line finished Stopped table: tf_rels in 1751s Copying tf_roads to cluster by geometry finished Creating indexes on tf_roads finished All indexes on tf_roads created in 22962s Completed tf_roads Copying tf_point to cluster by geometry finished Creating indexes on tf_point finished All indexes on tf_point created in 36052s Completed tf_point Copying tf_line to cluster by geometry finished Creating indexes on tf_line finished All indexes on tf_line created in 172385s Completed tf_line Copying tf_polygon to cluster by geometry finished Creating indexes on tf_polygon finished All indexes on tf_polygon created in 193522s Completed tf_polygon Stopped table: tf_ways in 223782s Osm2pgsql took 393444s overall