<p></p>
<p dir="auto">Another interesting observation that I now see is that, despite pgAdmin clearly showing the indexing statement for the <strong>"osm_id"</strong> column used in the DELETE, that the actual index is missing on the "planet_osm_point/line/polygon" tables: there are <strong>no indexes visible</strong> 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??:</p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer" href="https://user-images.githubusercontent.com/7635726/168449930-0bac7b90-be4d-4032-a85e-a340cd2d79d2.png"><img src="https://user-images.githubusercontent.com/7635726/168449930-0bac7b90-be4d-4032-a85e-a340cd2d79d2.png" alt="afbeelding" style="max-width: 100%;"></a></p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer" href="https://user-images.githubusercontent.com/7635726/168449625-ae9e2e62-0f30-4b68-a1b3-56207585f9d7.png"><img src="https://user-images.githubusercontent.com/7635726/168449625-ae9e2e62-0f30-4b68-a1b3-56207585f9d7.png" alt="afbeelding" style="max-width: 100%;"></a></p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer" href="https://user-images.githubusercontent.com/7635726/168449744-524d8150-fafb-4062-9f70-5c2a484895fa.png"><img src="https://user-images.githubusercontent.com/7635726/168449744-524d8150-fafb-4062-9f70-5c2a484895fa.png" alt="afbeelding" style="max-width: 100%;"></a></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/discussions/1642#discussioncomment-2752271">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353WFCC6FNSIUEWY2YRLVKARWXANCNFSM5OMS32RQ">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AA6353UFZE6OSQXF5GN3ZD3VKARWXA5CNFSM5OMS32R2YY3PNVWWK3TUL52HS4DFWFCGS43DOVZXG2LPNZBW63LNMVXHJKTDN5WW2ZLOORPWSZGOAAU76DY.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/repo-discussions/1642/comments/2752271</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/discussions/1642#discussioncomment-2752271",
"url": "https://github.com/openstreetmap/osm2pgsql/discussions/1642#discussioncomment-2752271",
"name": "View Discussion"
},
"description": "View this Discussion on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>