[Tile-serving] [openstreetmap/osm2pgsql] Something wrong with indexes during import (#1436)

[Andrey Novikov]

```
gis=# \d osm_lines
                  Unlogged table "public.osm_lines"
 Column │           Type            │ Collation │ Nullable │ Default 
────────┼───────────────────────────┼───────────┼──────────┼─────────
 way_id │ bigint                    │           │ not null │ 
 tags   │ hstore                    │           │          │ 
 names  │ hstore                    │           │          │ 
 geom   │ geometry(LineString,3857) │           │          │ 
Indexes:
    "osm_lines_way_id_idx" btree (way_id)
```

```
    table_schema    │           table_name           │ row_estimate │   total    │   index    │   toast    │   table    
────────────────────┼────────────────────────────────┼──────────────┼────────────┼────────────┼────────────┼────────────
 public             │ osm_ways                       │  7.45749e+08 │ 178 GB     │ 16 GB      │ 1398 MB    │ 161 GB
 public             │ osm_polygons                   │  5.14261e+08 │ 155 GB     │ 11 GB      │ 13 GB      │ 131 GB
 public             │ osm_lines                      │  2.20958e+08 │ 74 GB      │ 4733 MB    │ 2565 MB    │ 66 GB
 public             │ osm_points                     │            0 │ 17 GB      │ 0 bytes    │ 80 kB      │ 17 GB
 public             │ osm_routes                     │            0 │ 5751 MB    │ 0 bytes    │ 4273 MB    │ 1478 MB
 public             │ osm_rels                       │  8.71913e+06 │ 4157 MB    │ 187 MB     │ 298 MB     │ 3672 MB
```

-- 
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/1436#issuecomment-807543941
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210325/15bf9e46/attachment-0001.htm>