[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