[Tile-serving] [osm2pgsql-dev/osm2pgsql] Daylight Ingest and Slow Deletions (Discussion #2088)

[mboeringa]

> I'll give it another go with what's mentioned in the manual (work_mem looks especially small!).

@pyoung-sc 

Before you do that, _could you verify if the admin_level=2 boundaries are OK?_ E.g. just look at any country, for example France, to see if the boundary is correct. As you can see from the image, almost all were broken...

I re-downloaded all datasets from Facebook's site after they fixed the 'coastlines' datalink, and re-processed all of them with osmium and re-imported with osm2pgsql, but I am still seeing an issue with the admin boundaries. Note that other types of boundaries, e.g. national parks and nature reserves, are OK.

There is just one question slightly lingering in my head, I used the commands listed below in the shown order. I assume this is the correct workflow, but I do not re-number after merging the buildings, only after merging the second dataset with boundaries, at the very end. I assume this is the correct workflow, because secondarily re-numbering after merging the buildings and before applying the changes of the boundaries, would make the OSM ids of the boundaries that subsequently need to be changed in the "apply-changes" step invalid?

But can you verify you did the same?

```
osmium merge planet-v1.32.osm.pbf ml-buildings-v1.32.osm.pbf -o planet-ml-buildings-v1.32.osm.pbf

osmium apply-changes planet-ml-buildings-v1.32.osm.pbf admin-v1.32.osc.gz -o planet-ml-buildings-admin-v1.32.osm.pbf

osmium renumber planet-ml-buildings-admin-v1.32.osm.pbf -o daylight-all-v1.32.osm.pbf
```

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2088#discussioncomment-7378494
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2088/comments/7378494 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20231025/07d5ea49/attachment.htm>