[OSM-dev] osm2pgsql: super slow relations

Ramas ieskok at ramuno.lt
Tue Jul 17 15:03:55 BST 2012


Hi,
after some updates in my system osm2pgsql relation processing in slim mode
become very slow:

...
Node-cache: cache=100MB, maxblocks=12801*8192, allocation method=11
Mid: pgsql, scale=100 cache=100
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: -
Processing: Node(9142k 97.3k/s) Way(730k 10.44k/s) Relation(16262 0.71/s)
 parse time: *23107s*

Node stats: total(9142106), max(1828269276) in 94s
Way stats: total(730829), max(171855770) in 70s
Relation stats: total(16262), max(2284768) in *22943s*
...

All this time postgresql cpu usage was 100% without any errors or notices.
I tried different osm2pgsql, libgeos, postgis versions with no luck.
Any thoughts?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20120717/d1eb7898/attachment.html>


More information about the dev mailing list