[Tile-serving] [osm2pgsql-dev/osm2pgsql] osm2pgsql --append to existing imported slim database takes ages (Issue #2266)

[a14stoner]

> @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: 

![grafik](https://github.com/user-attachments/assets/41d851c9-1f8c-44d2-999d-646a1bb8b706)




-- 
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/2431443920 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20241023/1140766c/attachment.htm>