[Tile-serving] [openstreetmap/osm2pgsql] Importing with Dutch "Rijksdriehoekstelsel" projection (SRID 28992) fails (extremely slow) (Issue #1876)

[Jochen Topf]

I can't see anything in your command line/config that should pose a problem with a different projection. I would expect a different projection to be somewhat slower, because projections just need some time (the Mercator projection is handled internally in some highly optimized way, so it doesn't suffer from that as much). But the times you report are way slower than what I would expect.

Here are some things you can try:
1. Comment out parts of your code to see whether its only some layers that are the problem.
2. The only thing I can think of that's different between projections (except the transformation itself), is the validity check performed in the database. Maybe that's horrible slow for some reason in that projection. You can find the code in osm2pgsql where that trigger is configured and remove it temporarily to check that.

But all of those above don't explain why the import seems to be fast at first and then gets slower. If that's actually what's happening then it could be related to table filling up and making queries on that table slow because of a missing index. But that should a) not be happening anyway and b) is not related to projections!?

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1876#issuecomment-1373377062
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1876/1373377062 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230106/563de430/attachment.htm>