[OSM-dev] time osm2pgsql

Frederik Ramm frederik at remote.org
Fri May 15 09:49:51 BST 2009


Hi,

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

Sure it's ANALYZE and not CREATE INDEX (which I'd expect to run for at 
least a day on a full planet)?

ps auxw|grep postgis

will tell you what the database thinks it's doing.

Bye
Frederik





More information about the dev mailing list