Skip to content

Schedule the removal of a redundant index on lfs_objects_projects

Jerry Setorequested to merge
467119-schedule-unique-index-on-lfs-objects-projects-4 into master

What does this MR do and why?

This change is to schedule the removal of idx_lfs_objects_projects_on_project_id_lfs_object_id_repo_type from lfs_objects_projects

An excerpt from \d+ lfs_objects_projects

"idx_lfs_objects_projects_on_project_id_lfs_object_id_repo_type" UNIQUE, btree (project_id, lfs_object_id, repository_type)
"lfs_objects_projects_on_project_id_lfs_object_id_null_repo_type" UNIQUE, btree (project_id, lfs_object_id) WHERE repository_type IS NULL
"lfs_objects_projects_on_project_id_lfs_object_id_with_repo_type" UNIQUE, btree (project_id, lfs_object_id, repository_type) WHERE repository_type IS NOT NULL

More context from a previous MR: !179613 (merged)

References

Please include cross links to any resources that are relevant to this MR. This will give reviewers and future readers helpful context to give an efficient review of the changes introduced.

MR acceptance checklist

Please 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 #467119 (closed)

Merge request reports