[Tile-serving] [osm2pgsql] .o5m really slow compared to .osm.pbf (#473)

[Paul Norman]

Testing with `-O null`, 22000 cache, slim, flat-nodes and a 150923 planet I get 4301 k nodes/s with PBF and 1915 k nodes/s with o5m. This happened to be with a cmake build with included `-O2`, so I retried with git master, and got similar results, although slower in both cases.

There is however a difference between my test dataset and yours, I was testing on a full planet, and you've got a subset.

Could you try `osm2pgsql -d gis -S osm2pgsql.style -O null --flat-nodes nodes.bin --slim --cache 22000 --number-processes 1` with

* the roads as PBF
* the roads as o5m
* the planet as PBF
* the planet as o5m (`osmconvert planet-latest.osm.pbf -o=planet-latest.o5m`, takes about 15-30 minutes to convert)

You don't need to let it complete all the nodes, if you abort it after 60 seconds that's fine. Just do it the same on each test.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/473#issuecomment-151351505
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20151026/3d70c14b/attachment-0001.html>