[Tile-serving] [osm2pgsql-dev/osm2pgsql] New feature: Check location of OSM objects against list of regions (PR #2333)

[Jochen Topf]

joto left a comment (osm2pgsql-dev/osm2pgsql#2333)

> Just curious: what makes this processing by osm2pgsql so much faster than doing this in the database after the import?

I think this is mostly because everything happens in memory. Once the Locator is set up, the checks run completely in memory. The OSM data is loaded anyway as part of the osm2pgsql processing, so it is available for the check. Doing this in the database means getting all the data from disk, doing all the checks and then doing lots of database updates involving more IO including all the clever things the database has to do to keep consistent and all that. There is just so much more work involved.

Memory usage is negligable.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/pull/2333#issuecomment-2922535514
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/pull/2333/c2922535514 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250530/63eeb055/attachment.htm>