ubuntu@ip-10-159-16-105:~/osm2pgsql$ /usr/bin/time -v osm2pgsql -c -d gis --slim --cache 18000 --flat-nodes /mnt/flat/flat.nodes --cache-strategy dense --hstore --number-processes 4 /planet/planet-130509.osm.pbf osm2pgsql SVN version 0.83.0 (64bit id space) Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point NOTICE: table "planet_osm_point" does not exist, skipping NOTICE: table "planet_osm_point_tmp" does not exist, skipping Setting up table: planet_osm_line NOTICE: table "planet_osm_line" does not exist, skipping NOTICE: table "planet_osm_line_tmp" does not exist, skipping Setting up table: planet_osm_polygon NOTICE: table "planet_osm_polygon" does not exist, skipping NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping Setting up table: planet_osm_roads NOTICE: table "planet_osm_roads" does not exist, skipping NOTICE: table "planet_osm_roads_tmp" does not exist, skipping Using built-in tag processing pipeline Allocating memory for dense node cache Allocating dense node cache in one big chunk Node-cache: cache=18000MB, maxblocks=2304001*8192, allocation method=10 Mid: loading persistent node cache from /mnt/flat/flat.nodes Allocated space for persistent node cache file Maximum node in persistent node cache: 0 Mid: pgsql, scale=100 cache=18000 Setting up table: planet_osm_nodes NOTICE: table "planet_osm_nodes" does not exist, skipping NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes" Setting up table: planet_osm_ways NOTICE: table "planet_osm_ways" does not exist, skipping NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways" Setting up table: planet_osm_rels NOTICE: table "planet_osm_rels" does not exist, skipping NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels" Reading in file: /planet/planet-130509.osm.pbf Processing: Node(1889609k 983.7k/s) Way(182531k 21.05k/s) Relation(1873240 82.37/s) Standard exception processing way_id 2850557: TopologyException: side location conflict at 976932.27000000002 5539092.2199999997 Processing: Node(1889609k 983.7k/s) Way(182531k 21.05k/s) Relation(1934380 83.30/s) parse time: 33815s Node stats: total(1889609932), max(2297054215) in 1921s Way stats: total(182531224), max(220602108) in 8673s Relation stats: total(1934388), max(2917183) in 23221s 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... Maximum node in persistent node cache: 2297430015 110362759 ways are pending Using 4 helper-processes WARNING: Failed to fork helper processes 1. Trying to recover. WARNING: Failed to fork helper processes 2. Trying to recover. WARNING: Failed to fork helper processes 3. Trying to recover. Mid: loading persistent node cache from /mnt/flat/flat.nodes Maximum node in persistent node cache: 2297430015 Helper process 0 out of 1 initialised Process 0 finished processing 110362759 ways in 50491 sec All child processes exited 110362759 Pending ways took 50492s at a rate of 2185.75/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... Maximum node in persistent node cache: 2297430015 0 relations are pending Using 4 helper-processes WARNING: Failed to fork helper processes 1. Trying to recover. WARNING: Failed to fork helper processes 2. Trying to recover. WARNING: Failed to fork helper processes 3. Trying to recover. Mid: loading persistent node cache from /mnt/flat/flat.nodes Maximum node in persistent node cache: 2297430015 Process 0 finished processing 0 relations in 3 sec All child processes exited 0 Pending relations took 3s 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: 1889609932(100.00%), storage efficiency: 82.64% (dense blocks: 2232993, sparse nodes: 0), hit rate: 100.00% Sorting data and creating indexes for planet_osm_roads Maximum node in persistent node cache: 2297430015 Stopping table: planet_osm_nodes Stopping table: planet_osm_ways Stopping table: planet_osm_rels Building index on table: planet_osm_ways (fastupdate=off) Building index on table: planet_osm_rels (fastupdate=off) Stopped table: planet_osm_nodes in 0s Stopped table: planet_osm_rels in 374s Analyzing planet_osm_roads finished Analyzing planet_osm_line finished Analyzing planet_osm_point finished Analyzing planet_osm_polygon finished Copying planet_osm_roads to cluster by geometry finished Creating geometry index on planet_osm_roads Creating osm_id index on planet_osm_roads Creating indexes on planet_osm_roads finished All indexes on planet_osm_roads created in 6319s Completed planet_osm_roads Copying planet_osm_point to cluster by geometry finished Creating geometry index on planet_osm_point Creating osm_id index on planet_osm_point Creating indexes on planet_osm_point finished All indexes on planet_osm_point created in 10039s Completed planet_osm_point Copying planet_osm_line to cluster by geometry finished Creating geometry index on planet_osm_line Creating osm_id index on planet_osm_line Creating indexes on planet_osm_line finished All indexes on planet_osm_line created in 65890s Completed planet_osm_line Copying planet_osm_polygon to cluster by geometry finished Creating geometry index on planet_osm_polygon Creating osm_id index on planet_osm_polygon Creating indexes on planet_osm_polygon finished All indexes on planet_osm_polygon created in 87790s Completed planet_osm_polygon Stopped table: planet_osm_ways in 153201s Osm2pgsql took 237520s overall Command being timed: "osm2pgsql -c -d gis --slim --cache 18000 --flat-nodes /mnt/flat/flat.nodes --cache-strategy dense --hstore --number-processes 4 /planet/planet-130509.osm.pbf" User time (seconds): 42740.19 System time (seconds): 1904.13 Percent of CPU this job got: 18% Elapsed (wall clock) time (h:mm:ss or m:ss): 65:58:40 Average shared text size (kbytes): 0 Average unshared data size (kbytes): 0 Average stack size (kbytes): 0 Average total size (kbytes): 0 Maximum resident set size (kbytes): 22877404 Average resident set size (kbytes): 0 Major (requiring I/O) page faults: 189 Minor (reclaiming a frame) page faults: 7030325 Voluntary context switches: 225042922 Involuntary context switches: 872326 Swaps: 0 File system inputs: 42253944 File system outputs: 35915032 Socket messages sent: 0 Socket messages received: 0 Signals delivered: 0 Page size (bytes): 4096 Exit status: 0