Osm2pgsql/benchmarks/Dell R610 1 minute diff import

From OpenStreetMap Wiki
Jump to navigation Jump to search

This is the output of osm2pgsql importing a one minute diff

../osm2pgsql/osm2pgsql -C 1024 --number-processes=4 -G -a -s -S ./default.style -m -d osm /dev/shm/diff.osc
osm2pgsql SVN version 0.80.0-sly-s hack (32bit id space)

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE:  la table « planet_osm_point_tmp » n'existe pas, poursuite du traitement
Setting up table: planet_osm_line
NOTICE:  la table « planet_osm_line_tmp » n'existe pas, poursuite du traitement
Setting up table: planet_osm_polygon
NOTICE:  la table « planet_osm_polygon_tmp » n'existe pas, poursuite du traitement
Setting up table: planet_osm_roads
NOTICE:  la table « planet_osm_roads_tmp » n'existe pas, poursuite du traitement
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=1024MB, maxblocks=131073*8192, allocation method=11
Mid: pgsql, scale=100
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /dev/shm/diff.osc
Processing: Node(0k 0.1k/s) Way(0k 0.01k/s) Relation(0 0.00/s)  parse time: 4s

Node stats: total(161), max(1674440793) in 2s
Way stats: total(26), max(154996220) in 2s
Relation stats: total(0), max(0) in 0s
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 4 helper-processes
processing way (0k) at 0.00k/s
Process 3 finished processing 0 ways in 0 sec

Process 2 finished processing 0 ways in 0 sec

Process 0 finished processing 1 ways in 0 sec

Process 1 finished processing 1 ways in 0 sec

All child processes exited

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 4 helper-processes

Process 0 finished processing 0 relations in 0 sec

Process 3 finished processing 0 relations in 0 sec

Process 1 finished processing 0 relations in 0 sec

Process 2 finished processing 0 relations in 0 sec

All child processes exited

Completed planet_osm_point
node cache: stored: 129(100.00%), storage efficiency: 11.31% (dense blocks: 1, sparse nodes: 78), hit rate: 11.23%
Stopping table: planet_osm_rels
Stopped table: planet_osm_rels in 0s
Stopping table: planet_osm_ways
Stopped table: planet_osm_ways in 0s
Stopping table: planet_osm_nodes
Completed planet_osm_roads
Stopped table: planet_osm_nodes in 0s
Completed planet_osm_polygon
Completed planet_osm_line

Osm2pgsql took 4s overall

real    0m4.317s
user    0m0.024s
sys     0m0.048s
+ set +x
Sun Mar 18 19:06:57 CET 2012