[Tile-serving] [openstreetmap/osm2pgsql] osm2pgsql fails to create "osm_id" indexes on PostgreSQL 14 (Issue #1674)

[mboeringa]

Setting a dedicated non-public schema also solved the missing **"osm_id"** column index problem for the Planet import, unfortunately, it doesn't seem to solve the performance problem in PG14.

I do see processing going on when watching the incoming DELETE statements send by osm2pgsql in pgAdmin. However, it is just terribly slow. Processing one batch of records as defined in one SQL statement, seems to take a minute or so.

The DELETE process initiated by "There are X ways to reprocess" processing step of osm2pgsql started at 2:11 AM, and is now 6 hours later still on-going... 

It is almost as if PostgreSQL still ignores the **"osm_id"** index...

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

Message ID: <openstreetmap/osm2pgsql/issues/1674/1127257870 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220515/33dadbd0/attachment.htm>