[Geocoding] Local Mirror of OSM Data...

Emilie Laffray emilie.laffray at gmail.com
Fri Oct 23 11:31:22 BST 2009


2009/10/23 Peter Childs <pchilds at bcs.org>

>
> No I'm using...
>
> bzcat planet-latest.osm.bz2 | osmosis-0.31/bin/osmosis --read-xml
> file=/dev/stdin --write-pgsql database=map
>
> and apparently CPU usage, (according to TOP, (Give or take))
>
> osmosis 55%, postgres 15%, bzcat 12%
>
> Can't believe it takes 4 times the resources to convert XML that it takes
> to decompress a file.....
>
>
One of the thing that I do is to use the write-pgsql-dump task that is
faster. Then importing data with the copy command is pretty fast. If you
have a multicore machine, can you check the load for each processor? What is
the percentage value for wa?

Emilie Laffray
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20091023/750a9c96/attachment.html>


More information about the Geocoding mailing list