Geo: Add missing registry table indexes
Problem
I noticed that job_artifact_registry, lfs_object_registry, and file_registry do not have indexes on the state field. As far as I know, these missing indexes are not an immediate blocker for anything. But the state field is commonly queried, and I would expect these indexes to help performance here and there. Also we are exposed to future hidden performance bugs due to this issue.
Proposal
- Add those 3 indexes.
- Look for more indexes which are specified in the instructions to add a data type here and here, but which unexpectedly do not exist in Geo's structure.sql.
Edited by Michael Kozono