[OSM-dev] osm2pgsql slow on update import

Frederik Ramm frederik at remote.org
Tue Apr 5 10:58:16 BST 2011


Hi,

> Some specs of my setup:
> -Debian 64Bit
> -PostgreSQL 9.0.3, PostGIS 1.5.2; having its own physical drive with
> XFS -Intel(R) Core(TM)2 Quad CPU Q9505  @ 2.83GHz

Make sure you've got at least osm2pgsql r25198 (31st Jan) as this will
turn the "fastupdate" feature off. The impact of this is most
pronounced on Postgres 8.4 but seems to be present on 9.0 also. Turning
fastupdate off makes updates faster. Obviously!

Bye
Frederik




More information about the dev mailing list