mmd-osm left a comment (openstreetmap/openstreetmap-website#6347)
What a pity. I only did a quick performance check, but haven't validated
results :(
I have now pushed the first (union all) version. In my local test, it happens
to be about 10 times faster than the naive version. I suppose the values I'm
seeing in `EXPLAIN (verbose, analyze, buffers)` are in a similar way heavily
skewed by the somewhat low amount of data in my db. At least they're consistent
with the actual runtimes I'm seeing.
One thing you could maybe try out is the CHUNK_SIZE parameter. I've been
testing values of 100'000 and 1'000'000. The default value of 10'000 didn't
turn out to be the most efficient.
--
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/6347#issuecomment-3227436202
You are receiving this because you are subscribed to this thread.
Message ID:
<openstreetmap/openstreetmap-website/pull/6347/[email protected]>
_______________________________________________
rails-dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/rails-dev
