Skip to content

Drop unused index in ci_builds

Max Orefice requested to merge morefice/drop-unused-index-ci-builds into master

Ref: #386268 (closed)

What does this MR do and why?

This MR drops an unused index on gitlab.com.

We successfully created our unique index this weekend so we can remove the current invalid invalid index that we have in production.

Indexes:
-   "index_ci_builds_on_token_encrypted_partition_id_unique" UNIQUE, btree (token_encrypted, partition_id) WHERE token_encrypted IS NOT NULL INVALID
    "unique_ci_builds_token_encrypted_and_partition_id" UNIQUE, btree (token_encrypted, partition_id) WHERE token_encrypted IS NOT NULL

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports