[Tile-serving] [openstreetmap/osm2pgsql] looong wait after "Completed planet_osm_polygon" (#993)

[Redoute]

Hi all,

When using osm2pgsql, in my case after about 10 hours I see the message "Completed osm_polygon" and the database seems complete and usable.

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?

I am using PostgreSQL 11.5 on Ubuntu and osm2pgsql 10.0.18362.418 on Windows with the command line
`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`

The pbf is 6.5 GB and was merged from several files from geofabrik.de, Germany and surroundings.

In PGAdmin I see an active session executing
`CREATE INDEX osm_ways_nodes ON osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF) ;`
Seems this step is no more necessary when all lines are already constructed?

Last lines of output are:
```
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%
```

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/993
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20191121/e70faa38/attachment.html>