Writing to pgsql on my machine took about a day with most of the indexing removed.
The bzip2 algorithims in java are pretty slow. It's usually quicker to do something like "bzcat planet-081217.osm.bz2 | ./osmosis --rx file=/dev/stdin --blah blah blah. Note that the planet expands to about 150GB in raw form, so your 100GB HD will not be enough. -Jeremy ----- Original Message ----- From: Bernardo Elayda To: [email protected] Sent: Saturday, December 20, 2008 2:34 PM Subject: [OSM-newbies] Typically, how long lo load a planet file? Hi! My setup is as follows: Ubunutu 8.04 (512 MB, 100GB HD) Ruby v1.8.7 RoR 2.0.2 Mysql v5.0.51a I'm currently loading a planet file using the following options for Osmosis: osmosis --read-xml file="planet-081217.osm.bz2" compressionMethod="bzip2" --write-mysql host="localhost" database="openstreetmap" user="openstreetmap" password="openstreetmap" validateSchemaVersion="no" How long does this typically take to complete? Should I have added some options to speed things up? When I top to watch things, it seems like osmosis is spending lots of time not running. tia, Bernie ------------------------------------------------------------------------------ _______________________________________________ newbies mailing list [email protected] http://lists.openstreetmap.org/listinfo/newbies
_______________________________________________ newbies mailing list [email protected] http://lists.openstreetmap.org/listinfo/newbies
