Skip to content

Drop unused indexes on the users table

Krasimir Angelov requested to merge ka/drop-indexes-on-require_two_factor_authentication_from_group into master

What does this MR do and why?

This MR drops:

  • index_users_require_two_factor_authentication_from_group_false
  • index_users_on_require_two_factor_authentication_from_group

as they are not used.

See #429090 (closed) and #429088 (closed).

Rollback

In case we need to recreate these index manually, here are the commands to do it:

create index concurrently "index_users_on_require_two_factor_authentication_from_group" on users(require_two_factor_authentication_from_group) WHERE require_two_factor_authentication_from_group = true;

create index concurrently "index_users_require_two_factor_authentication_from_group_false" on users(require_two_factor_authentication_from_group) WHERE require_two_factor_authentication_from_group = false

It should takes less than 10 minutes in production:

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