Drop index can be blocked for a long time
Follow-up to gitlab-com/gl-infra/production#4440 (comment 565320697)
Dropping the index should not result in a long transaction when blocked. Check if we can use with_lock_retries
Edited by Andreas Brandl