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/[email protected]>
_______________________________________________
rails-dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/rails-dev
