[Tile-serving] [openstreetmap/osm2pgsql] osm2pgsql fails to create "osm_id" indexes on PostgreSQL 14 (Issue #1674)

[mboeringa]

@joto 

I think one problem is clear, indeed no ANALYZE before the DELETE statements start being emitted by osm2pgsql. Interesting question remains why this is far less of an issue in PG13 than 14. Obviously, and likely, there may have been changes in the PostgreSQL planner that cause the difference:

```
2022-05-19 21:13:24  Creating id index on table 'planet_osm_line'...
2022-05-19 21:13:24  SQL: CREATE INDEX ON "osm"."planet_osm_line" USING BTREE (osm_id)  TABLESPACE "osm_k"
2022-05-19 21:13:24  Creating id index on table 'planet_osm_polygon'...
2022-05-19 21:13:24  SQL: CREATE INDEX ON "osm"."planet_osm_polygon" USING BTREE (osm_id)  TABLESPACE "osm_i"
2022-05-19 21:13:24  Creating id index on table 'planet_osm_transport_line'...
2022-05-19 21:13:24  SQL: CREATE INDEX ON "osm"."planet_osm_transport_line" USING BTREE (osm_id)  TABLESPACE "osm_j"
2022-05-19 21:13:24  Creating id index on table 'planet_osm_transport_polygon'...
2022-05-19 21:13:24  SQL: CREATE INDEX ON "osm"."planet_osm_transport_polygon" USING BTREE (osm_id)  TABLESPACE "osm_j"
2022-05-19 21:13:24  Creating id index on table 'planet_osm_admin'...
2022-05-19 21:13:24  SQL: CREATE INDEX ON "osm"."planet_osm_admin" USING BTREE (osm_id)  TABLESPACE "osm_k"
2022-05-19 21:13:24  Creating id indexes took 0s
2022-05-19 21:13:24  There are 1808 ways to reprocess...
2022-05-19 21:13:24  SQL: EXECUTE get_way(5363222)
etc...
2022-05-19 21:13:24  SQL: EXECUTE get_way(966204123)
2022-05-19 21:13:24  Dropping table 'planet_osm_nodes'
2022-05-19 21:13:24  SQL: DROP TABLE IF EXISTS "planet_osm_nodes"
2022-05-19 21:13:24  Table 'planet_osm_nodes' dropped in 0s
2022-05-19 21:13:24  Dropping table 'planet_osm_ways'
2022-05-19 21:13:24  SQL: DROP TABLE IF EXISTS "planet_osm_ways"
2022-05-19 21:13:25  Table 'planet_osm_ways' dropped in 1s
2022-05-19 21:13:25  Dropping table 'planet_osm_rels'
2022-05-19 21:13:25  SQL: DROP TABLE IF EXISTS "planet_osm_rels"
2022-05-19 21:13:25  Table 'planet_osm_rels' dropped in 0s
2022-05-19 21:13:25  Done postprocessing on table 'planet_osm_nodes' in 0s
2022-05-19 21:13:25  Done postprocessing on table 'planet_osm_ways' in 0s
2022-05-19 21:13:25  Done postprocessing on table 'planet_osm_rels' in 0s
2022-05-19 21:13:25  Clustering table 'planet_osm_point' by geometry...
2022-05-19 21:13:25  SQL: SET client_min_messages = WARNING
2022-05-19 21:13:25  SQL: DELETE FROM "osm"."planet_osm_polygon" WHERE osm_id IN (30969680,75393724,75393727,75393730,75393732,75393733,75393736,75393737,75393739,753
etc...
```

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1674#issuecomment-1132118515
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1674/1132118515 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220519/93d516b6/attachment.htm>