> an index on author+date+id
`+id` is probably not necessary. If a user managed to create multiple objects
during the same microsecond we can afford picking a wrong one. Or select
min/max(id) where created_at is between target_date and target_date+/-epsilon.
--
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/5531#issuecomment-2605921298
You are receiving this because you are subscribed to this thread.
Message ID:
<openstreetmap/openstreetmap-website/pull/5531/c2605921...@github.com>
_______________________________________________
rails-dev mailing list
rails-dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/rails-dev