Talk:Osm2pgsql/Benchmarks

From OpenStreetMap Wiki
Jump to: navigation, 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