• Mikolaj Wawrzyniak's avatar
    Recreate broken ci_builds index · 3c69765c
    Mikolaj Wawrzyniak authored
    ServicePing report generation for gitlab.com instance performace has
    suddenly decreased over last week. After investigation it appears
    that one of specialized indexes that supported heavy query included in
    the report is marked as invalid. Following PostgreSQL documentation
    advice to recreate index in such case.
    At https://gitlab.com/gitlab-org/gitlab/-/merge_requests/71712
    broken index was renamed as broken and new one was scheduled
    to be re created. This commit adds migration with synchronouse index
    creation for self-managed instances.
    
    Changelog: performance
    3c69765c
20211013125341 64 Bytes