sudo -u www-data osm2pgsql -C 2048 --number-processes 8 --slim india-latest.osm.pbf osm2pgsql SVN version 0.81.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 Allocating memory for dense node cache Allocating dense node cache in block sized chunks Node-cache: cache=2048MB, maxblocks=0*262145, allocation method=8192 Mid: pgsql, scale=100 cache=2048 Setting up table: planet_osm_nodes 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: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways" Setting up table: planet_osm_rels NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels" Reading in file: india-latest.osm.pbf Processing: Node(13666k 83.8k/s) Way(821k 2.01k/s) Relation(7710 35.05/s) parse time: 791s Node stats: total(13666635), max(2147451695) in 163s Way stats: total(821155), max(228425911) in 408s Relation stats: total(7715), max(3059567) in 220s 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... 153444 ways are pending Using 8 helper-processes Process 5 finished processing 19180 ways in 220 sec Process 6 finished processing 19180 ways in 220 sec Process 7 finished processing 19180 ways in 220 sec Process 4 finished processing 19180 ways in 234 sec Process 0 finished processing 19181 ways in 234 sec Process 1 finished processing 19181 ways in 234 sec Process 2 finished processing 19181 ways in 235 sec Process 3 finished processing 19181 ways in 235 sec All child processes exited 153444 Pending ways took 235s at a rate of 652.95/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... 0 relations are pending Using 8 helper-processes Process 0 finished processing 0 relations in 0 sec Process 3 finished processing 0 relations in 2 sec Process 1 finished processing 0 relations in 2 sec Process 2 finished processing 0 relations in 2 sec Process 7 finished processing 0 relations in 2 sec Process 5 finished processing 0 relations in 2 sec Process 6 finished processing 0 relations in 2 sec Process 4 finished processing 0 relations in 2 sec All child processes exited 0 Pending relations took 2s at a rate of 0.00/s Sorting data and creating indexes for planet_osm_line Sorting data and creating indexes for planet_osm_polygon Sorting data and creating indexes for planet_osm_point Sorting data and creating indexes for planet_osm_roads node cache: stored: 13666635(100.00%), storage efficiency: 9.64% (dense blocks: 138482, sparse nodes: 0), hit rate: 0.00% Analyzing planet_osm_point finished Analyzing planet_osm_polygon finished Analyzing planet_osm_roads finished Analyzing planet_osm_line finished Copying planet_osm_point to cluster by geometry finished Copying planet_osm_roads to cluster by geometry finished Creating indexes on planet_osm_roads finished All indexes on planet_osm_roads created in 191s Completed planet_osm_roads Copying planet_osm_polygon to cluster by geometry finished Creating indexes on planet_osm_point finished All indexes on planet_osm_point created in 212s Completed planet_osm_point Creating indexes on planet_osm_polygon finished All indexes on planet_osm_polygon created in 224s Completed planet_osm_polygon Copying planet_osm_line to cluster by geometry finished Creating indexes on planet_osm_line finished All indexes on planet_osm_line created in 657s Completed planet_osm_line Stopping table: planet_osm_rels Stopping table: planet_osm_ways Stopping table: planet_osm_nodes Stopped table: planet_osm_nodes in 0s Building index on table: planet_osm_rels (fastupdate=off) Building index on table: planet_osm_ways (fastupdate=off) Stopped table: planet_osm_rels in 20s Stopped table: planet_osm_ways in 349s Osm2pgsql took 2135s overall