> @a14stoner
>
> One other thing I noticed is that you are still using HDD. The osm2pgsql
> manual clearly recommends (NVMe) SSDs due to the need for fast random access
> during some stages of the processing:
>
> https://osm2pgsql.org/doc/manual.html#disk
>
> Even if you can swap out the disks for only a single SATA SSD drive, it might
> help the processing speed. However, NVMe PCIe 3.0 4x/8x/16x adaptors and a
> relatively small 1TB NVMe drive should cost you little, and be easy to
> install in older hardware.
doe to the budget reasons i cant get ssds in my company for this server ;(
> Hm. Just noticed something weird. The offending query looks like you are
> using the old middle database format. But from the command line it looks like
> you are using the new one. Can you show us the contents of the
> osm2pgsql_properties table?
This is the result:
--
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/issues/2266#issuecomment-2431443920
You are receiving this because you are subscribed to this thread.
Message ID: <osm2pgsql-dev/osm2pgsql/issues/2266/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving
