spacepaste

Paste details

reply | raw

  1.  
  2. sudo -u www-data osm2pgsql -C 2048 --number-processes 8 --slim india-latest.osm.pbf
  3. osm2pgsql SVN version 0.81.0 (64bit id space)
  5. Using projection SRS 900913 (Spherical Mercator)
  6. Setting up table: planet_osm_point
  7. NOTICE: table "planet_osm_point" does not exist, skipping
  8. NOTICE: table "planet_osm_point_tmp" does not exist, skipping
  9. Setting up table: planet_osm_line
  10. NOTICE: table "planet_osm_line" does not exist, skipping
  11. NOTICE: table "planet_osm_line_tmp" does not exist, skipping
  12. Setting up table: planet_osm_polygon
  13. NOTICE: table "planet_osm_polygon" does not exist, skipping
  14. NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
  15. Setting up table: planet_osm_roads
  16. NOTICE: table "planet_osm_roads" does not exist, skipping
  17. NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
  18. Allocating memory for dense node cache
  19. Allocating dense node cache in block sized chunks
  20. Node-cache: cache=2048MB, maxblocks=0*262145, allocation method=8192
  21. Mid: pgsql, scale=100 cache=2048
  22. Setting up table: planet_osm_nodes
  23. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"
  24. Setting up table: planet_osm_ways
  25. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"
  26. Setting up table: planet_osm_rels
  27. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"
  29. Reading in file: india-latest.osm.pbf
  30. Processing: Node(13666k 83.8k/s) Way(821k 2.01k/s) Relation(7710 35.05/s) parse time: 791s
  32. Node stats: total(13666635), max(2147451695) in 163s
  33. Way stats: total(821155), max(228425911) in 408s
  34. Relation stats: total(7715), max(3059567) in 220s
  35. Committing transaction for planet_osm_point
  36. Committing transaction for planet_osm_line
  37. Committing transaction for planet_osm_polygon
  38. Committing transaction for planet_osm_roads
  40. Going over pending ways...
  41. 153444 ways are pending
  43. Using 8 helper-processes
  44. Process 5 finished processing 19180 ways in 220 sec
  45. Process 6 finished processing 19180 ways in 220 sec
  46. Process 7 finished processing 19180 ways in 220 sec
  47. Process 4 finished processing 19180 ways in 234 sec
  48. Process 0 finished processing 19181 ways in 234 sec
  49. Process 1 finished processing 19181 ways in 234 sec
  50. Process 2 finished processing 19181 ways in 235 sec
  51. Process 3 finished processing 19181 ways in 235 sec
  53. All child processes exited
  55. 153444 Pending ways took 235s at a rate of 652.95/s
  56. Committing transaction for planet_osm_point
  57. Committing transaction for planet_osm_line
  58. Committing transaction for planet_osm_polygon
  59. Committing transaction for planet_osm_roads
  61. Going over pending relations...
  62. 0 relations are pending
  64. Using 8 helper-processes
  65. Process 0 finished processing 0 relations in 0 sec
  66. Process 3 finished processing 0 relations in 2 sec
  67. Process 1 finished processing 0 relations in 2 sec
  68. Process 2 finished processing 0 relations in 2 sec
  69. Process 7 finished processing 0 relations in 2 sec
  70. Process 5 finished processing 0 relations in 2 sec
  71. Process 6 finished processing 0 relations in 2 sec
  72. Process 4 finished processing 0 relations in 2 sec
  74. All child processes exited
  75. 0 Pending relations took 2s at a rate of 0.00/s
  77. Sorting data and creating indexes for planet_osm_line
  78. Sorting data and creating indexes for planet_osm_polygon
  79. Sorting data and creating indexes for planet_osm_point
  80. Sorting data and creating indexes for planet_osm_roads
  81. node cache: stored: 13666635(100.00%), storage efficiency: 9.64% (dense blocks: 138482, sparse nodes: 0), hit rate: 0.00%
  82. Analyzing planet_osm_point finished
  83. Analyzing planet_osm_polygon finished
  84. Analyzing planet_osm_roads finished
  85. Analyzing planet_osm_line finished
  86. Copying planet_osm_point to cluster by geometry finished
  87. Copying planet_osm_roads to cluster by geometry finished
  88. Creating indexes on planet_osm_roads finished
  89. All indexes on planet_osm_roads created in 191s
  90. Completed planet_osm_roads
  91. Copying planet_osm_polygon to cluster by geometry finished
  92. Creating indexes on planet_osm_point finished
  93. All indexes on planet_osm_point created in 212s
  94. Completed planet_osm_point
  95. Creating indexes on planet_osm_polygon finished
  96. All indexes on planet_osm_polygon created in 224s
  97. Completed planet_osm_polygon
  98. Copying planet_osm_line to cluster by geometry finished
  99. Creating indexes on planet_osm_line finished
  100. All indexes on planet_osm_line created in 657s
  101. Completed planet_osm_line
  102. Stopping table: planet_osm_rels
  103. Stopping table: planet_osm_ways
  104. Stopping table: planet_osm_nodes
  105. Stopped table: planet_osm_nodes in 0s
  106. Building index on table: planet_osm_rels (fastupdate=off)
  107. Building index on table: planet_osm_ways (fastupdate=off)
  108. Stopped table: planet_osm_rels in 20s
  109. Stopped table: planet_osm_ways in 349s
  111. Osm2pgsql took 2135s overall
  112.  
Powered by spacepaste. Paste removal.