[OSM-dev] Update osm2pgsql patch mode

Robert (Jamie) Munro rjmunro at arjam.net
Fri Aug 29 16:23:34 BST 2008


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Martijn van Oosterhout wrote:
> Due to the generous contribution of a (loan of a) machine from Richard
> Duivenvoorde I had the opportunity to examime the bottlenecks in the
> osm2pgsql patching process. I fixed a number of stupid problems and
> switched to GIN indexes. It now takes on this machine 24 hours to load
> the planet dump (!) (that's with 1.5GB cache) but it can apply a daily
> diff in 100 minutes and a minute diff in seconds.
> 
> I hope to be able to analyze exactly where the time is going over the
> next while to see what improvements can be made (I'm sure there's
> lots). I'll let you know how it goes.

Great progress - that's now about 14 times real time.

How much disc space does the whole operation require?

Robert (Jamie) Munro


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAki4FHQACgkQz+aYVHdncI2xyACgyfXluf6nLCBxIMHEN1veQ2mm
U3QAniSwP/a5rqFcj9pd88ktVob2M6cg
=eGeL
-----END PGP SIGNATURE-----




More information about the dev mailing list