Le samedi 08 mai 2010 01:11:10, vous avez écrit : > 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.
Ooops sorry, I considered too quickly that diff import or initial import would produce same kind of behaviour. > The node changes were > reasonably fast, and then it took ages to process the way changes. I re-tried on my two setup a one hour diff import (but the loaded database is almost empty with just http://download.geofabrik.de/osm/europe/france/alsace.osm.bz2 so it could lead to other types of results. Interestingly, this time, loading the one hour diff took 2'33" on the postgres 8.4 and 1'10" on postgres 8.3 Trying on the exact same machine with a much wider initial import could be interesting to test, but all this let me think I'd better postpone my 8.4 migration. Anyway thanks for the feed back -- sly sylvain letuffe _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev