[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,
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.
Bye
Frederik
More information about the dev
mailing list