Skip to content

Remove duplicated index from board_user_preferences

Leonardo da Rosa requested to merge remove-duplicated-indexes-board_user_preferences into master

What does this MR do and why?

Remove duplicated index from board_user_preferences table.

It removes:

Drop index_board_user_preferences_on_user_id as it's already covered by:

Index Columns
index_board_user_preferences_on_user_id_and_board_id user_id asc, board_id asc

It is possible that this MR will still need some changes to drop the index from the database. Currently, the gitlab-housekeeper is not always capable of removing all references, so you must check the diff and pipeline failures to confirm if there are any issues. Ensure that the index exists in the production database by checking Joe Bot trough https://console.postgres.ai/gitlab. If the index was already removed or if the index it's being removed in another merge request, consider closing this merge request.

This change was generated by gitlab-housekeeper using the Keeps::RemoveDuplicatedIndexes keep.

To provide feedback on your experience with gitlab-housekeeper please comment in #442003 (closed).

Merge request reports