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/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving
