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

[mboeringa]

@joto 

If I need to determine if this is a PostgreSQL issue or osm2pgsql one, it would be helpful if you could answer two minor questions. These are probably easily answered, as likely not requiring more than a superficial look at the osm2pgsql code, or maybe you can even answer them from the top of your head knowing the code base so well:

- Does osm2pgsql run ANALYZE directly after creating the indexes on the "osm_id" columns, so the PostgreSQL planner is garantueed to know of their existence and usefulness before osm2pgsql starts emitting the DELETE statements for the "There are X ways to reprocess" stage?
- How many "osm_id" values are included in each batch as defined by the DELETE's "IN" clause? 100, 1000, 10k? If I need to simulate what osm2pgsql does in order to reproduce the issue in PostgreSQL without involvement of osm2pgsql, this is vital information.

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

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