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

[wgds60]

The fixation on --number-processes was a misleading path, everything seems to be fine with --number-processes.

I now downgraded osm2pgsql from 1.8.1 to 1.60 for testing but to no avail.

--append is still about 10 times slower than on an older osm2pgsql setup with postgresql 10, osm2pgsql 1.20 and postgis 2.4.

Tried both the settings for postgresql as used in that old setup as well as the ones recommended at osm2pgsql.org.

Initial import (--create mode) is way faster than the older setup, but the hardware is also better. It's like twice as fast, about 7 to 8 hours for a planet import.

But the --append mode unbearable slow with like 0.5k/s node processing instead of 5k/s node processing. Overall --append operation is like 5 to 10 times slower.

I still have the feeling of being stupid in missing sth. obvious.... 

E.g. as this is a test with osm-carto, I haven't applied the indexes.sql from osm-carto yet, but I thought only osm2pgsqls indexes are important for osm2pgsql processes and the style-specific ones are just for the rendering...

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

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