Missing compound indexes for uniqueness constraints

[tarebyte]

As I was going through the application today I noticed that in almost every case where we are requiring uniqueness via scope.

Documentation: https://www.postgresql.org/docs/11/indexes-multicolumn.html

I'm opening up a tracking issue to keep tabs on these, it's not 🔥 urgent but as the app gets more traffic this is something we're going to want to do.

Here is the list of every missing compound index I found:

• [ ] Assignment
  • slug and organization_id
• [ ] AssignmentRepo
  • assignment_invitation_id and user_id
• [ ] Group
  • slug and grouping_id
• [ ] GroupAssignment
  • slug and organization_id
• [ ] GroupInviteStatus
  • group_assignment_invitation_id and group_id
• [ ] Grouping
  • slug and organization_id
• [ ] InviteStatus
  • assignment_invitation_id and user_id
• [ ] Organization
  • title and github_id
• [ ] RepoAccess
  • user_id and organization_id

Let me know if I can help clarify or expand upon any of this.

Thanks :sparkles:

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. Thank you for your contributions.