[Tile-serving] [osm2pgsql-dev/osm2pgsql] parallelize the COPY phase (Discussion #2426)

[Tomas Vondra]

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/14825501 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20251030/62d7314e/attachment.htm>