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

Steve Singer ssinger_pg at sympatico.ca
Sat May 8 00:24:15 BST 2010


On Sat, 8 May 2010, Frederik Ramm wrote:

> 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.


Also monitor the physical size on disk of your database disk during the 
process.  Check to see if it is getting substantially larger (more so than 
what you would expect with normal  osm data growth) at some point during the 
process.



>
> Bye
> Frederik
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>





More information about the dev mailing list