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} :)
|
_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk
