[openstreetmap/openstreetmap-website] Add indexes on user+id to changeset and diary comments (PR #5531)

[Anton Khorev]

> 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/c2605921298 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250121/d3367280/attachment.htm>