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

[Paul Norman]

pnorman left a comment (openstreetmap/openstreetmap-website#6570)

> nearby changesets (to the user's profile location) are slow and often time out.

I wouldn't use PostGIS just for this. Bounding boxes can be handled reasonably well without postgis. Do you have an link to the timeout issue?

Anti-vandalism restrictions are a better use-case as a point-in-polygon check is difficult to do in the DB without postgis. 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 recommend staying away from computing any distances with PostGIS. It runs into all sorts of projection problems unless you only have points, and even the point one is a problem because can't be indexed easily.



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

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