[OSM-dev] planet.osm
Nicola Ranaldo
ranaldo at unina.it
Fri Aug 25 15:18:55 BST 2006
> I believe my UTF8sanitizer filters out bad UTF8:
> <www.lysator.liu.se/~jonass/UTF8sanitizer.c>. May be hard to use
> unless you are used to unix & C & and compiling.
>
> /Jonas
Ok it passed the expat parsing!
To import the entire file with no bounding-box reduction on a machine with
low memory i used the db to lookup for existents node and segments.
This slows the import process. On a dualcore 3.0 ghz the import was about 18
hours long on postgres. I think i can achieve better results with mysql, but
the problem will be presented again while data continues to grow.
We should begin to think at a binary planet.osm too.
I'm just trying planetosm-to-db.sql too , top reports it's using 1.6Gb of ram!
Niko
More information about the dev
mailing list