ubuntu@ip-10-10-254-25:~/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 --tag-transform-script style.lua /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 lua based tag processing pipeline with script style.lua 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 526.1k/s) Way(182531k 18.81k/s) Relation(1873240 67.31/s) Standard exception processing way_id 2850557: TopologyException: side location conflict at 976932.27000000002 5539092.2199999997 Processing: Node(1889609k 526.1k/s) Way(182531k 18.81k/s) Relation(1934380 67.94/s) parse time: 41765s Node stats: total(1889609932), max(2297054215) in 3592s Way stats: total(182531224), max(220602108) in 9703s Relation stats: total(1934388), max(2917183) in 28470s 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 110803870 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 110803870 ways in 49899 sec All child processes exited 110803870 Pending ways took 49899s at a rate of 2220.56/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 4 sec All child processes exited 0 Pending relations took 4s 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 Analyzing planet_osm_roads finished Stopped table: planet_osm_rels in 372s Analyzing planet_osm_point finished Analyzing planet_osm_line 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 3410s 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 9938s 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 84518s 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 108146s Completed planet_osm_polygon Stopped table: planet_osm_ways in 161699s Osm2pgsql took 253378s overall Command being timed: "osm2pgsql -c -d gis --slim --cache 18000 --flat-nodes /mnt/flat/flat.nodes --cache-strategy dense --hstore --number-processes 4 --tag-transform-script style.lua /planet/planet-130509.osm.pbf" User time (seconds): 44272.26 System time (seconds): 1928.36 Percent of CPU this job got: 18% Elapsed (wall clock) time (h:mm:ss or m:ss): 70:22:58 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): 22847556 Average resident set size (kbytes): 0 Major (requiring I/O) page faults: 199 Minor (reclaiming a frame) page faults: 6920988 Voluntary context switches: 241639178 Involuntary context switches: 1042909 Swaps: 0 File system inputs: 33958776 File system outputs: 35921704 Socket messages sent: 0 Socket messages received: 0 Signals delivered: 0 Page size (bytes): 4096 Exit status: 0 ubuntu@ip-10-10-254-25:~/osm2pgsql$