> 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/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving
