[Tile-serving] [openstreetmap/osm2pgsql] Improve performance of processing diff files (#1528)

[Jochen Topf]

The `PREPARE` SQL statements are definitely not the bottle neck, they basically don't take any time at all. When checking active queries in PostgreSQL the last queries are reported even if the connection is now idle. That's probably what you are seeing. There is some flag that shows whether the question is actually running, don't know off the top of my hat what that was called.

Anyway: We are fully aware that the processing in osm2pgsql is not always using as many threads as it theoretically could and there are ways to make things faster, but it is not so easy to do that and changes in that area will need quite a lot of effort.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1528#issuecomment-862486305
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210616/d3dbc565/attachment.htm>