[Tile-serving] [osm2pgsql-dev/osm2pgsql] Up speed flex output with --create (Discussion #2341)

[mboeringa]

> Yes, I am mistaked, but inserting 0.12k ways per second is equal "never" for all planet data. )

> Yes, with flat-nodes it will write nodes on to disk, but it needing about 200gb for all planet. I have't this amount on my notebook, and tried this option early.

If you only get **0.12k ways per second**, you really should look at both your hardware and PostgreSQL configuration. Based on the second comment, it sounds to me you may be using a secondary HDD instead of NVMe SSD due to lack of space on the probably NVMe SSD based system disk of your laptop.

I get **70k ways/s** on [2016 hardware](https://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks#Planet_(86.5GB_PBF,_2025-04-21)_on_HP_Z840_workstation,_512GB_DDR4_2133,_2x_Xeon_E5-2699v4_22C,_5x_Samsung_970_EVO_Plus_2TB_NVMe_RAID_0,_2x_Intel_OPTANE_905P_960GB_NVMe_RAID_0,_Ubuntu_24.04/PG17.4_(flex_|_--slim)_~10.5h), albeit upgraded with a NVMe SSDs. 

Alternatively, there may be an issue with some inappropriate or hugely complex Lua Flex style processing for your particular style, that simply makes it slow. With all the flexibility, you can introduce performance problems of your own making.

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

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2341/comments/13389709 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250606/3f47a5cd/attachment.htm>