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

[mboeringa]

Another interesting observation that I now see is that, despite pgAdmin clearly showing the indexing statement for the **"osm_id"** column used in the DELETE, that the actual index is missing on the "planet_osm_point/line/polygon" tables: there are **no indexes visible** in pgAdmin and DBeaver. The lack of indexes, could definitely explain the poor performance. But why does this fail in PostgreSQL 14, and not 13??:

![afbeelding](https://user-images.githubusercontent.com/7635726/168449930-0bac7b90-be4d-4032-a85e-a340cd2d79d2.png)

![afbeelding](https://user-images.githubusercontent.com/7635726/168449625-ae9e2e62-0f30-4b68-a1b3-56207585f9d7.png)

![afbeelding](https://user-images.githubusercontent.com/7635726/168449744-524d8150-fafb-4062-9f70-5c2a484895fa.png)



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

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