Changelog: other

Changelog: other

## What does this MR do and why?

Remove duplicated index from `boards_epic_board_recent_visits` table.

### It removes:

Drop `index_boards_epic_board_recent_visits_on_user_id` as it's already covered by:
| Index | Columns |
| ----- | ------ |
| `index_epic_board_recent_visits_on_user_group_and_board` | `user_id asc`, `group_id asc`, `epic_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](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::RemoveDuplicatedIndexes keep.

To provide feedback on your experience with `gitlab-housekeeper` please comment in
<https://gitlab.com/gitlab-org/gitlab/-/issues/442003>.

Changelog: other

## What does this MR do and why?

Remove duplicated index from `boards_epic_user_preferences` table.

### It removes:

Drop `index_boards_epic_user_preferences_on_board_id` as it's already covered by:
| Index | Columns |
| ----- | ------ |
| `index_boards_epic_user_preferences_on_board_user_epic_unique` | `board_id asc`, `user_id asc`, `epic_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](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::RemoveDuplicatedIndexes keep.

To provide feedback on your experience with `gitlab-housekeeper` please comment in
<https://gitlab.com/gitlab-org/gitlab/-/issues/442003>.

Changelog: other

## 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](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::RemoveDuplicatedIndexes keep.

To provide feedback on your experience with `gitlab-housekeeper` please comment in
<https://gitlab.com/gitlab-org/gitlab/-/issues/442003>.

Changelog: other

## What does this MR do and why?

Remove duplicated index from `board_project_recent_visits` table.

### It removes:

Drop `index_board_project_recent_visits_on_user_id` as it's already covered by:
| Index | Columns |
| ----- | ------ |
| `index_board_project_recent_visits_on_user_project_and_board` | `user_id asc`, `project_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](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::RemoveDuplicatedIndexes keep.

To provide feedback on your experience with `gitlab-housekeeper` please comment in
<https://gitlab.com/gitlab-org/gitlab/-/issues/442003>.

Changelog: other

This finder implements a more performance version of the query used for
`Group#sbom_occurrences`. Is able to perform aggregations one page at a
time, while the current implementation of `Group#sbom_occurrences` must
read all the records in the group before aggregating them and then
finally applying the limit.

This commit drops ci_runner_machine_builds_on_runner_machine_id
index as this is a duplicated index for this table and we do not
need it.

Changelog: other

This index was removed with
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/150728.

See
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/150728#note_1890789185
for more details.

[skip-db-structure-check]

Added unprepare_async_index_by_name to remove the failed migration from postgres_async_indexes table

See https://docs.gitlab.com/ee/development/database/avoiding_downtime_in_migrations.html#swap-the-columns-release-n--1

Changelog: changed

This commit creates the routing table for ci_stages.

Changelog: other

Contributes to https://gitlab.com/gitlab-org/gitlab/-/issues/428548

Remove duplicates indexes:

* Remove "index_protected_tags_on_project_id" duplicated by
"index_protected_tags_on_project_id_and_name"
* Remove duplicated "index_project_repositories_on_shard_id" index
* Remove duplicated "index_approvals_on_merge_request_id" index
* Remove index_approval_project_rules_users_on_approval_project_rule_id

Changelog: performance

This commit creates the routing table for ci_job_artifacts.

Changelog: other

in place of component_id.

EE: true
Changelog: fixed

component_version_id and input_file_path.

EE: true
Changelog: added

This commit removes old index and foreign key which are no
longer being used.

Changelog: performance

Changelog: performance

This commit removes old indexes and foreign keys which are no
longer being used.

Changelog: performance

 Remove package_registry duplicated indexes that already covered by other indexes.

 Changelog: changed

This code was merged into TestProf gem so we can now rely
on the gem

Changelog: changed

This commit adds new indexes including the partition_id key in
order to partition ci_job_artifacts table.

Changelog: added

Changelog: other

EE: true
Changelog: changed

This is to step to remove the trigger and old integer column
See https://docs.gitlab.com/ee/development/database/avoiding_downtime_in_migrations.html#remove-the-trigger-and-old-integer-columns-release-n--2

Changelog: changed

This is a duplicated index.

Changelog: performance

This is a duplicated index.

Changelog: performance

This is a duplicated index.

Changelog: performance

This is a duplicated index.

Changelog: performance

This is a duplicated index.

Changelog: performance

This is a duplicated index.

Changelog: performance