[Tile-serving] [osm2pgsql-dev/osm2pgsql] Is loading nodes to a --flat-nodes file using lat/lon 4326 slower than 3857? (Discussion #2272)

[mboeringa]

This is still a preliminary observation, but for some testing, I now used the new 'openstreetmap-carto-flex' and the --flat-nodes option of osm2pgsql.

While, if I have understood it well from previous discussions here in the repository, the loading data as 3857 is faster in general due to some shortcuts in the code, I generally assumed this would not relate to the --flat-nodes loading stage, as I assumed the major difference would likely be in processing ways and relations in the different projections.

But I now noticed a slightly higher node loading speed (7k/s versus 5.8k/s) using the new  'openstreetmap-carto-flex' style that loads data as 3857, while I routinely process the data as 4326 using my own custom flex style, which results in the lower figure.

This also raises another question: does --flat-nodes store node data always in 4326 as per the OpenStreetMap PBF, or in the style's defined projection (which might explain the difference I am seeing)?

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2272
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2272 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20241205/705a9680/attachment.htm>