[OSM-dev] osm2pgsql slow on update import

Lennard ldp at xs4all.nl
Sat May 7 18:47:04 BST 2011

On 7-5-2011 18:46, Sven Geggus wrote:
> Jukka Rahkonen<jukka.rahkonen at latuviitta.fi>  wrote:
>> Am I right in thinking that if there were suitable diffs available it
>> would be much faster to update directly the osm_point, osm_line and
>> osm_polygon tables without going through osm_points, osm_ways and
>> osm_rels?
> This would not work because these tables are different depending on
> the stylefile used.

Fully self-referential diffs would be good for one thing: no need to 
fetch the unchanged nodes of a way to rebuild the geometry.

They would potentially be much much larger than the current diffs, so 
that's a clear argument against them.


More information about the dev mailing list