[OSM-dev] speeding up loading an OSM dump into PostGIS?

Erik Johansson emj at kth.se
Wed Nov 30 06:45:11 GMT 2011


On Wed, Nov 30, 2011 at 07:25, Ákos Maróy <akos at maroy.hu> wrote:
> thus, I wonder, what good ways are there to speed up this process?
>
> or, to put it in the other perspective: what hardware would make be
> needed to make this process faster?

According to the benchmark page SSD can make things fast. Europe was
apparently imported in 8 hours vs 60 hours with spinning media.

http://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks#sly.27s_benchmark_05.2F2010_.28influence_of_SSD.2C_software_RAID_and_memory_on_import_and_diffs.29



-- 
/emj



More information about the dev mailing list