[OSM-talk] Is this normal ?

[Simon Gornall]

So, I'd set everything up on my Ubuntu linux box, and decided to time the import for posterity...

www:/opt/gis> time osm2pgsql -s -v -U simon -d gis -C 7000 data/planet-latest.osm  
osm2pgsql SVN version 0.66-

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Mid: pgsql, scale=100, cache=7000MB, maxblocks=896001*8192
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: data/planet-latest.osm
Processing: Node(593072k) Way(45376k) Relation(484k)
Node stats: total(593072533), max(696096737)
Way stats: total(45376969), max(55410575)
Relation stats: total(484528), max(555276)

Going over pending ways
processing way (13679k)

Going over pending relations

node cache: stored: 593072533(100.00%), storage efficiency: 86.21%, hit rate: 100.00%
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_roads
Sorting data and creating indexes for planet_osm_polygon
Sorting data and creating indexes for planet_osm_line
Committing transaction for planet_osm_point
Sorting data and creating indexes for planet_osm_point
ANALYZE planet_osm_roads;
 failed: ERROR:  could not access status of transaction 4026772988
DETAIL:  Could not open file "pg_clog/0F00": No such file or directory.

Error occurred, cleaning up
12523.240u 403.910s 7:13:16.49 49.7%	0+0k 266220448+0io 10515pf+0w


I'm a bit concerned about the red bit above...


The graph of cpu-usage was pretty interesting... {CPU}...{DISK}...{CPU}   :)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20100425/62c61e40/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cpu-day.png
Type: image/png
Size: 22027 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20100425/62c61e40/attachment.png>