[OSM-dev] Postgres 8.4 performance trouble in osm2pgsql setup

Frederik Ramm frederik at remote.org
Sat May 8 00:11:10 BST 2010


sly (sylvain letuffe) wrote:
> Test case :
> wget http://download.geofabrik.de/osm/europe/france/alsace.osm.bz2
> time osm2pgsql -C 1200 -s -S ./default.style -G -x -m -d gis ./alsace.osm.bz2
> (...)

The intial import went all right on 8.3 and 8.4; my "4 times slower" was 
about adding a daily diff to the data base. The node changes were 
reasonably fast, and then it took ages to process the way changes. I 
think I'll instrument osm2pgsql to produce intermediate timestamps for 
the various steps.


More information about the dev mailing list