> 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

Reply via email to