Skip to content

Remove partial_index_deployments_for_project_id_and_tag

Problem

See Reduce main database load by optimizing `deploy... (&10169)

As of 2023-04-14, this index has the following usage rates according to Thanos

type rate
{type="patroni-ci"} 0
{type="patroni"} 0
{type="patroni-main-logical-pg13"} 0
{type="postgres-archive"} 0
{type="postgres-delayed"} 0

Proposal

https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#drop-indexes-asynchronously

Edited by Pam Artiaga