Osm2pgsql/benchmarks/Custom server vm import 2

From OpenStreetMap Wiki
Jump to navigation Jump to search
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