Talk:Osm2pgsql/Benchmarks
Jump to navigation
Jump to search
raw results for Frederik's 2011-11-14 planet run
osm2pgsql -d osm --tablespace-main-data ssd --tablespace-main-index ssd -C 15000 -U osm --slim -r pbf --number-processes 6 --cache-strategy dense planet-latest.osm.pbf ... Processing: Node(1255668k 136.7k/s) Way(113827k 16.68k/s) Relation(1165190 37.14/s) parse time: 47378s Node stats: total(1255668203), max(1496003906) in 9183s Way stats: total(113827607), max(136372064) in 6825s Relation stats: total(1165199), max(1836918) in 31370s 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 Using 6 helper-processes processing way (10343k) at 0.86k/s All child processes exited Pending ways took 12008s at a rate of 5168.33/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 Using 6 helper-processes All child processes exited Pending relations took 3s at a rate of 0.00/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 Sorting data and creating indexes for planet_osm_point Sorting data and creating indexes for planet_osm_polygon Sorting data and creating indexes for planet_osm_roads Sorting data and creating indexes for planet_osm_line node cache: stored: 1255668203(100.00%), storage efficiency: 84.45% (dense blocks: 1452046, sparse nodes: 0), hit rate: 100.00% Stopping table: planet_osm_nodes Stopping table: planet_osm_rels Stopping table: planet_osm_ways Building index on table: planet_osm_rels (fastupdate=off) Stopped table: planet_osm_nodes in 0s Building index on table: planet_osm_ways (fastupdate=off) Stopped table: planet_osm_rels in 133s Indexes on planet_osm_roads created in 1852s Completed planet_osm_roads Indexes on planet_osm_point created in 3358s Completed planet_osm_point Indexes on planet_osm_line created in 10462s Completed planet_osm_line Indexes on planet_osm_polygon created in 10734s Completed planet_osm_polygon Stopped table: planet_osm_ways in 76467s Osm2pgsql took 135862s overall