Re: [OSM-dev] Memory error while converting osm to gml

2009-04-04 Thread Martijn van Oosterhout
2009/4/4 Matt Amos : > 2009/4/4 Martijn van Oosterhout : >> Just reading this again made me realise that we could probably make >> osm2pgsql faster for the common case just by forking and using >> gzip/bzip2 to do the decompression in a separate process (i.e. another >> CPU)... Not entirely sure ho

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-04 Thread Stefan de Konink
Matt Amos wrote: > 2009/4/4 Martijn van Oosterhout : >> Just reading this again made me realise that we could probably make >> osm2pgsql faster for the common case just by forking and using >> gzip/bzip2 to do the decompression in a separate process (i.e. another >> CPU)... Not entirely sure how mu

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-04 Thread Matt Amos
2009/4/4 Martijn van Oosterhout : > Just reading this again made me realise that we could probably make > osm2pgsql faster for the common case just by forking and using > gzip/bzip2 to do the decompression in a separate process (i.e. another > CPU)... Not entirely sure how much you'd save though (I

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-04 Thread Martijn van Oosterhout
2009/4/3 Stefan de Konink : > What I have seen using gzip and bzip2 on the fly decompression on 5x > raid0, only one CPU was busy decompressing and the actual tool had a cpu > time of .30. It was clear that first decompressing then running the tool > on an mmap file was faster. Just reading this a

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Stefan de Konink
Iván Sánchez Ortega wrote: > El Jueves, 2 de Abril de 2009, Stefan de Konink escribió: >> Does anyone have any timings on importing the current planet.osm in >> PostgreSQL with any tool available? Using lets say 8GB of ram and >> 'typical' disk? > > I can only say that I imported a planet (with cu

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Brett Henderson
Stefan de Konink wrote: > Does anyone have any timings on importing the current planet.osm in > PostgreSQL with any tool available? Using lets say 8GB of ram and > 'typical' disk? > I don't have full numbers but I do have some figures which may be useful. Early in January Jochen Topf did some

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Matt Amos
2009/4/2 Stefan de Konink : > Matt Amos wrote: >> so you'd need to either store >> all the node locations in ram or some external indexed format... which >> is exactly what osm2pgsql does :-) > > mmap the node table in array index form to disk, that will work because of > hole allocation, that will

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Iván Sánchez Ortega
El Jueves, 2 de Abril de 2009, Stefan de Konink escribió: > Does anyone have any timings on importing the current planet.osm in > PostgreSQL with any tool available? Using lets say 8GB of ram and > 'typical' disk? I can only say that I imported a planet (with custom, non-OSM data) worth 170m node

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Stefan de Konink
Matt Amos wrote: > 2009/4/2 Stefan de Konink : >> Iván Sánchez Ortega wrote: >>> El Jueves, 2 de Abril de 2009, Will Nordin escribió: I am trying to convert the planet-090319.osm (approx 107GB) to gml. I've tried the Java and Python solutions, but both end up thorwing OutOfMemory exc

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Matt Amos
2009/4/2 Stefan de Konink : > Iván Sánchez Ortega wrote: >> El Jueves, 2 de Abril de 2009, Will Nordin escribió: >>> I am trying to convert the planet-090319.osm (approx 107GB) to gml. I've >>> tried the Java and Python solutions, but both end up thorwing OutOfMemory >>> exceptions. >> >> Man, it's

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Stefan de Konink
Iván Sánchez Ortega wrote: > El Jueves, 2 de Abril de 2009, Will Nordin escribió: >> I am trying to convert the planet-090319.osm (approx 107GB) to gml. I've >> tried the Java and Python solutions, but both end up thorwing OutOfMemory >> exceptions. > > Man, it's one-frakking-hundred gigabytes, ho

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Frederik Ramm
Hi, Iván Sánchez Ortega wrote: > You should try splitting the planet with Osmosis first, then individually > converting each of the pieces to GML. ... but first make sure that the tools you wish to process the resulting GML with are actually capable of handling that amount of data ;-) Dependin

Re: [OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Iván Sánchez Ortega
El Jueves, 2 de Abril de 2009, Will Nordin escribió: > I am trying to convert the planet-090319.osm (approx 107GB) to gml. I've > tried the Java and Python solutions, but both end up thorwing OutOfMemory > exceptions. Man, it's one-frakking-hundred gigabytes, how would it *not* cause OOM errors?!

[OSM-dev] Memory error while converting osm to gml

2009-04-02 Thread Will Nordin
I am trying to convert the planet-090319.osm (approx 107GB) to gml. I've tried the Java and Python solutions, but both end up thorwing OutOfMemory exceptions. Has anyone successfully converted the planet osm to gml. If so, how is it done? And even better, does anyone know where an already conver