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

[mboeringa]

I attached the style as ZIP. 

However, I don't think it is actually that relevant. This is more of a generic question: is it efficient to delete large numbers of records in batches using IN statements, or is it potentially faster to process using the suggested SQL statement? I have never tested this in PostgreSQL, and don't know if there are potential differences, although the PostgreSQL Help suggests there may be differences depending on the used SQL (in relation to sub-select versus USING clause).

[openstreetmap-carto.zip](https://github.com/openstreetmap/osm2pgsql/files/8063587/openstreetmap-carto.zip)



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

Message ID: <openstreetmap/osm2pgsql/issues/1640/1039496816 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220214/843639f2/attachment.htm>