<p></p>
<p dir="auto">Setting a dedicated non-public schema also solved the missing <strong>"osm_id"</strong> column index problem for the Planet import, unfortunately, it doesn't seem to solve the performance problem in PG14.</p>
<p dir="auto">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.</p>
<p dir="auto">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...</p>
<p dir="auto">It is almost as if PostgreSQL still ignores the <strong>"osm_id"</strong> index...</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/issues/1674#issuecomment-1127257870">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353QCHQLE7MWA3K3G6A3VKHRETANCNFSM5V6VPZVA">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AA6353S2EZ6AAOQCYARMDTTVKHRETA5CNFSM5V6VPZVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOIMYJODQ.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span><openstreetmap/osm2pgsql/issues/1674/1127257870</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/osm2pgsql/issues/1674#issuecomment-1127257870",
"url": "https://github.com/openstreetmap/osm2pgsql/issues/1674#issuecomment-1127257870",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>