[openstreetmap/openstreetmap-website] Backfill enhanced changeset stats (PR #6347)

[mmd]

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/c3227436202 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250827/167054a4/attachment.htm>