[Tile-serving] [openstreetmap/osm2pgsql] Slow --append node processing with osm2pgsql 1.8.1 (7-8* slower than older setup) (Discussion #1971)

[wgds60]

Hi rustprooflabs, thanks for chimming in, esp. with your postgresql expertise. The problem is: I had been at 5k/s with an old setup (on nvme, slightly slower on ssd), but now I only get 1/10 of that - esp. in node processing (only 0.5k/s at the current test run) with newer, better hw and newer versions of postgresql, osm2pgsql and postgis.

Currently I do have that suspicion that sth. is wrong in the number of threads used. It's not the 10 I specified and it's not the 4 (default?) but rather the number of logical cores used - for whatever reason.

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

Message ID: <openstreetmap/osm2pgsql/repo-discussions/1971/comments/6091702 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230605/ed99ed6e/attachment.htm>