<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>So, I'd set everything up on my Ubuntu linux box, and decided to time the import for posterity...</div><div><br></div><div>www:/opt/gis> time osm2pgsql -s -v -U simon -d gis -C 7000 data/planet-latest.osm </div></div><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;">osm2pgsql SVN version 0.66-<br><br>Using projection SRS 900913 (Spherical Mercator)<br>Setting up table: planet_osm_point<br>Setting up table: planet_osm_line<br>Setting up table: planet_osm_polygon<br>Setting up table: planet_osm_roads<br>Mid: pgsql, scale=100, cache=7000MB, maxblocks=896001*8192<br>Setting up table: planet_osm_nodes<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"<br>Setting up table: planet_osm_ways<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"<br>Setting up table: planet_osm_rels<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"<br><br>Reading in file: data/planet-latest.osm<br>Processing: Node(593072k) Way(45376k) Relation(484k)<br>Node stats: total(593072533), max(696096737)<br>Way stats: total(45376969), max(55410575)<br>Relation stats: total(484528), max(555276)<br><br>Going over pending ways<br>processing way (13679k)<br><br>Going over pending relations<br><br>node cache: stored: 593072533(100.00%), storage efficiency: 86.21%, hit rate: 100.00%<br>Committing transaction for planet_osm_line<br>Committing transaction for planet_osm_polygon<br>Committing transaction for planet_osm_roads<br>Sorting data and creating indexes for planet_osm_roads<br>Sorting data and creating indexes for planet_osm_polygon<br>Sorting data and creating indexes for planet_osm_line<br>Committing transaction for planet_osm_point<br>Sorting data and creating indexes for planet_osm_point<br><span class="Apple-style-span" style="color: rgb(249, 10, 23); ">ANALYZE planet_osm_roads;</span><br><span class="Apple-style-span" style="color: rgb(249, 10, 23); "> failed: ERROR: could not access status of transaction 4026772988</span><br><span class="Apple-style-span" style="color: rgb(249, 10, 23); ">DETAIL: Could not open file "pg_clog/0F00": No such file or directory.</span><br><br>Error occurred, cleaning up<br>12523.240u 403.910s 7:13:16.49 49.7%<span class="Apple-tab-span" style="white-space:pre"> </span>0+0k 266220448+0io 10515pf+0w</blockquote><div><div><br></div><div><br></div><div>I'm a bit concerned about the red bit above...</div><div><br></div><div><br></div></div><div>The graph of cpu-usage was pretty interesting... {CPU}...{DISK}...{CPU} :)</div><div><br></div><div><img id="ddd00d5d-a111-49e8-9dda-166a3bb2d0ad" height="359" width="497" apple-width="yes" apple-height="yes" src="cid:3308BFD6-15B4-4ABE-AFED-F86323359A46"></div></body></html>