[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