<p>Hi all,</p>
<p>When using osm2pgsql, in my case after about 10 hours I see the message "Completed osm_polygon" and the database seems complete and usable.</p>
<p>But it takes another 24 hours until osm2pgsql finishes. I observed this twice now. Is this a problem with osm2pgsql or PostgreSQL or am I missing something?</p>
<p>I am using PostgreSQL 11.5 on Ubuntu and osm2pgsql 10.0.18362.418 on Windows with the command line<br>
<code>C:\Daten2\osm2pgsql-bin\osm2pgsql.exe --host ubuntu.forplan.local --username postgres --password --slim --cache 30000 --proj 32632 --hstore --hstore-add-index --keep-coastlines --multi-geometry --prefix osm --style C:\Daten2\osm2pgsql-bin\fds.style C:\Daten2\osm-2019-11-06.pbf</code></p>
<p>The pbf is 6.5 GB and was merged from several files from geofabrik.de, Germany and surroundings.</p>
<p>In PGAdmin I see an active session executing<br>
<code>CREATE INDEX osm_ways_nodes ON osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF) ;</code><br>
Seems this step is no more necessary when all lines are already constructed?</p>
<p>Last lines of output are:</p>
<pre><code>Completed osm_polygon
Stopped table: osm_ways in 107130s

Osm2pgsql took 129500s overall
node cache: stored: 894447560(100.00%), storage efficiency: 50.00% (dense blocks: 0, sparse nodes: 894447560), hit rate: 100.00%
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/issues/993?email_source=notifications&email_token=AA6353SI3ERNL6Q5XU5TPTLQUZBIDA5CNFSM4JP6WBJ2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4H3A2FPA">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353VL66O5OORN4EBL6IDQUZBIDANCNFSM4JP6WBJQ">unsubscribe</a>.<img src="https://github.com/notifications/beacon/AA6353ROEJ56RUYJ37ZI73LQUZBIDA5CNFSM4JP6WBJ2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4H3A2FPA.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/osm2pgsql/issues/993?email_source=notifications\u0026email_token=AA6353SI3ERNL6Q5XU5TPTLQUZBIDA5CNFSM4JP6WBJ2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4H3A2FPA",
"url": "https://github.com/openstreetmap/osm2pgsql/issues/993?email_source=notifications\u0026email_token=AA6353SI3ERNL6Q5XU5TPTLQUZBIDA5CNFSM4JP6WBJ2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4H3A2FPA",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>