[OSM-dev] Reducing osm2pgsql memory usage using a database method

Jon Burgess jburgess777 at googlemail.com
Sat Mar 10 13:40:11 GMT 2007


I've just uploaded an experimental version of osm2pgsql which uses
Postgresql database tables for the transient node and segment storage.
This drops the memory usage from >1GB to ~60MB. On the downside, the
import time has gone up from 20 to 100 minutes. I'm sure this can be
improved though with some more database Mojo.

For further details see SVN (utils/osm2pgsql/experimental/readme.txt)
or
http://trac.openstreetmap.org/browser/utils/osm2pgsql/experimental/readme.txt


	Jon






More information about the dev mailing list