[Tile-serving] [openstreetmap/osm2pgsql] Stage 2 flex processing is slow (possible issue with DELETE statement?) (Discussion #1642)

[mboeringa]

@lonvia and @joto ,

After upgrading a second time from PostgreSQL 13 to 14, this time to the just released PostgreSQL 14.3 that contains a fix for a crucial blocking bug that I experienced with 14.2, I again experience a significant slow down in the processing of the DELETE statement as shown in the original post https://github.com/openstreetmap/osm2pgsql/discussions/1642#discussion-3876871.

As mentioned there, at that stage of the osm2pgsql processing, the only activity going on and initiated by osm2pgsql is these repititive DELETE statements with large IN clauses.

As I have now experienced this issue a second time after upgrade from 13 to 14, I am strongly suspecting this is a performance regression issue in PostgreSQL 14.

Does one of you have experienced similar issues yourself when upgrading from 13 to 14 and specifically at that stage of **"There are X ways to reprocess..."**?

Or have you possibly heard of other people experiencing such issues after upgrade to PostgreSQL 14?

I may try to put a question out on the PostGIS list to see if there any other people who experienced a performance regression on DELETE with large IN clauses after upgrade.

By the way: Am I right these DELETE statements aren't PREPAREd? Could that possibly make a difference here?


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

Message ID: <openstreetmap/osm2pgsql/repo-discussions/1642/comments/2752173 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220514/04313f1b/attachment.htm>