[Tile-serving] [openstreetmap/osm2pgsql] Loading ways in non-slim mode is slower than with --slim. (Discussion #2014)

[mboeringa]

Ok, thanks for the explanation, especially regarding the compressed storage format of non-slim imported middle data.

Funny thing is, and this is of course coincidence, but with my current hardware configuration, and after the commit https://github.com/openstreetmap/osm2pgsql/pull/2007 that seems to have made the import of relations 25% faster in **--slim** mode, and with Planet's current ratio of ways:relations of approximately **100:1**, I now end up with nearly equivalent import times for slim + flat-nodes on the one hand, and non-slim on the other.

Both are now approximately 8 hours for a full Planet import using a custom openstreetmap-carto derived style.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/discussions/2014#discussioncomment-6533404
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/repo-discussions/2014/comments/6533404 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230724/d39ad5e7/attachment.htm>