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

[Frederik Ramm]

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