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

Peter Körner osm-lists at mazdermind.de
Fri Dec 16 11:49:34 GMT 2011


Am 16.12.2011 12:47, schrieb Hartmut Holzgraefe:
> On 16.12.2011 11:21, Peter Körner wrote:
>
>> At one of the Hack-Weekends someone played around with distributing the
>> SQL-Commands issued by osm2pgsql via XMPP.
>
> with the SQL command execution, especially the index creation, being
> the most expensive part of an osm2pgsql run this would onyl save about
> 1/4 to 1/3 of the total planet import execution time i'm afraid ...
>

It would help with keeping updated: you would not need the --slim tables 
anymore (on each server - only on the master)

Peter



More information about the dev mailing list