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

[Tom Hughes]

Well then you'd ideally want an index on author+date+id though we have to think about how much space we want o use on indexes at some point - is here really a need for filtering by date? How often do you know that you need to look at comments from a particular date?

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

Message ID: <openstreetmap/openstreetmap-website/pull/5531/c2605861788 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250121/16cc8810/attachment.htm>