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

[mboeringa]

After downgrading to PostgreSQL 13.5 due to a bug in PG 14.2, I can't seem to reproduce this issue. I see it finish in about 15 minutes now + another 15 minutes for some indexing (Planet). This seems reasonable. 

Either there was an issue with PG 14.2, or simply some other (maintenance?) process of PostgreSQL causing the slow processing, although I can't remember seeing any activity like that displayed in pgAdmin when I examined the processing delay.

Will keep a look out though for issues if I attempt to upgrade to PG 14 another time once 14.3 is released.

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

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