[Tile-serving] [openstreetmap/osm2pgsql] Flex output is trying to create ID index on tables without IDs (#1507)

[Jochen Topf]

We probably shouldn't try to create an index on ids on a table that doesn't have them. But with two-stage processing you really need that index, otherwise it will become horribly slow.

In your case I don't see why you can't have an id colum, though. Just create the `way_nodes` tables as a normal way table and the `relation_members` table as a normal relations table. They'll have the id that osm2pgsql needs. Then add your own composite index on `(way_id, node_ref)`. This will add some overhead due to the two indexes, but it gives osm2pgsql what it needs and you what you need. If you do a non-slim import or use `--drop`, you don't need the index any more after the import and you can drop it (or maybe its not generated at all, I am not sure at the moment).

-- 
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/1507#issuecomment-844068957
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210519/7dbcef70/attachment.htm>