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

[Redoute]

Thanks, but all indexing on the four resulting tables seem to finish in the first 10 hours. Why waste 24 hours more on an index on a "slim" table, after all the real work is done? And why does this one take that long? This is the corresponding output:

```
Sorting data and creating indexes for osm_roads
Sorting data and creating indexes for osm_point
Sorting data and creating indexes for osm_line
Sorting data and creating indexes for osm_polygon
Copying osm_roads to cluster by geometry finished
Creating geometry index on osm_roads
Creating osm_id index on osm_roads
Creating hstore indexes on osm_roads
Creating indexes on osm_roads finished
All indexes on osm_roads created in 1045s
Completed osm_roads
Stopping table: osm_nodes
Stopped table: osm_nodes in 0s
Stopping table: osm_ways
Building index on table: osm_ways
Copying osm_point to cluster by geometry finished
Creating geometry index on osm_point
Creating osm_id index on osm_point
Creating hstore indexes on osm_point
Creating indexes on osm_point finished
All indexes on osm_point created in 3927s
Completed osm_point
Stopping table: osm_rels
Building index on table: osm_rels
Stopped table: osm_rels in 132s
Copying osm_line to cluster by geometry finished
Creating geometry index on osm_line
Creating osm_id index on osm_line
Creating hstore indexes on osm_line
Creating indexes on osm_line finished
All indexes on osm_line created in 8935s
Completed osm_line
Copying osm_polygon to cluster by geometry finished
Creating geometry index on osm_polygon
Creating osm_id index on osm_polygon
Creating hstore indexes on osm_polygon
Creating indexes on osm_polygon finished
All indexes on osm_polygon created in 13885s
Completed osm_polygon
```

... and 24 hours later

```
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 commented.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/993#issuecomment-557097632
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20191121/86fb9746/attachment.html>