[OSM-dev] time osm2pgsql

Lennard ldp at xs4all.nl
Fri May 15 08:19:57 BST 2009

Sam Mor wrote:
> and now after 7 hours still the same:
> Going over pending relations
> node cache: stored: 104740975(31.71%), storage efficiency: 99.89%, hit rate: 31.36%

Yes, it can take a long time. Did you tune your postgresql according to 
http://wiki.openstreetmap.org/wiki/Mapnik/PostGIS#Tuning_the_database ?

An extra line in osm2pgsql, where it tells you it's doing the ANALYZE, 
could be handy as well. When I first started using osm2pgsql, I've been 
wondering too what it was doing, and if it might be hanging.


More information about the dev mailing list