Draft: Reintroduce composite index_ssh_signatures_on_project_id_and_commit_sha for ssh_signatures table

Javiera Tapiarequested to merge
jtapiab/583644-reintroduce-composite-index-ssh-signatures into master

What does this MR do and why?

There was an original MR that attempted to:

  • Drop index_ssh_signatures_on_commit_sha and redundant index_ssh_signatures_on_project_id indexes
  • Add a new composite index index_ssh_signatures_on_project_id_and_commit_sha

This change is needed for Cells to ensure that the unique index by commit_sha is still unique for the ssh_signatures table. This MR was reverted: Revert "Cells: Add composite index index_ssh_si... (!215953 - merged)

References

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #583644

Merge request reports