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

Frederik Ramm frederik at remote.org
Fri Dec 16 11:52:14 GMT 2011


Hi,

On 12/16/11 12:49, Peter Körner wrote:
>> 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)

At the cost of high network traffic - a single node moved in the outline 
of the Germany polygon would mean that a geometry with tens of thousands 
of points would have to be pushed from the master to the clients.

Bye
Frederik



More information about the dev mailing list