[openstreetmap/openstreetmap-website] Enable PostGIS (Issue #6570)

[mmd]

mmd-osm left a comment (openstreetmap/openstreetmap-website#6570)

> I do wonder if checking every geom and child geom for each object edit is a good idea. A relation edit can easily have tens of thousands of nodes as descendants.

I'm also expecting abysmal performance in that case, in particular for our worst case candidates with 15k ways and almost 500k nodes (Lake Huron). Maybe we need to move some of the more expensive anti-vandalism checks to an asynchronous background job, rather than blocking the upload for minutes. Like I mentioned in https://github.com/openstreetmap/openstreetmap-website/issues/6568#issuecomment-3587441347 this all highly depends on the actual requirements.



-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/6570#issuecomment-3592490900
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/issues/6570/3592490900 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20251130/2bcf3441/attachment-0001.htm>