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

Ævar Arnfjörð Bjarmason avarab at gmail.com
Sat May 8 17:06:13 BST 2010


On Fri, May 7, 2010 at 23:11, Frederik Ramm <frederik at remote.org> wrote:
> 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.

Has this been reported upstream? If there's a simple-ish testcase for
it bisecting to where the problem is shouldn't be too hard..




More information about the dev mailing list