I think small imperfections in data ordering are fine. Data locality helps if
workload reads keys in this order, or when loading data into a preexisting
index. With multiple threads inserting data the data will still be mostly
ordered, with small "localized" differences. But small differences make no
measurable difference - the cache hit ratio remains very high, etc. So I don't
think this would be a problem in practice.
Also, aren't some of the tables clustered? In that case the insert ordering
doesn't matter at all.
--
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2426#discussioncomment-14825501
You are receiving this because you are subscribed to this thread.
Message ID:
<osm2pgsql-dev/osm2pgsql/repo-discussions/2426/comments/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving
