Misskey GitHub Notifier @mi.osamu-storage.info @repo@mi.osamu-storage.info
Public

💬 Commented on "enhance(backend): DB note (userId) インデクス -> (userId, id) 複合インデクスにする": atsu1125 "FYI, this migration took 8 minutes for an instance with a database size of 54 GB."
https://github.com/misskey-dev/misskey/pull/15879#issuecomment-2841640790

Fixes #11094 What Replaced the user ID only index in note table with composite ones. QueryService.ts#makePaginationQuery always order by the primary key so a composite index should handle this case...

enhance(backend): DB note (userId) インデクス -> (userId, id) 複合インデクスにする by eternal-flame-AD · Pull Request #15879 · misskey-dev/misskey

Fixes #11094 What Replaced the user ID only index in note table with composite ones. QueryService.ts#makePaginationQuery always order by the primary key so a composite index should handle this case...

github.com · GitHub

1
0
0

If you have a fediverse account, you can quote this note from your own instance. Search https://mi.osamu-storage.info/notes/a77efw099xbu03vr on your instance and quote it. (Note that quoting is not supported in Mastodon.)