Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Register
  • Sign in
  • G gitlab-ce
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 0
    • Issues 0
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 1
    • Merge requests 1
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Metrics
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • nexedinexedi
  • gitlab-ce
  • Repository
  • gitlab-ce
  • lib
  • gitlab
  • database
  • postgres_index.rb
Find file BlameHistoryPermalink
  • Andreas Brandl's avatar
    Expand index selection strategy for reindexing · 2d15b97d
    Andreas Brandl authored Jul 07, 2021
    We change strategy to select indexes for reindexing:
    
    1. Consider relative bloat levels instead of absolute bloat
    1. Exclude GIN indexes (risk for GitLab.com)
    1. Exclude indexes with relative bloat level < 20%
    1. Exclude indexes < 1 GB ondisk size (not worth it for now)
    1. Exclude indexes > 100 GB ondisk size (risk for GitLab.com)
    1. Don't reindex an index twice within 10 days
    
    Together with adding support for unique indexex in
    https://gitlab.com/gitlab-org/gitlab/-/merge_requests/64695, this
    aims to distribute reindexing actions better across indexes and exclude
    the risky ones.
    
    Relates to:
    
    - https://gitlab.com/gitlab-org/gitlab/-/issues/335295
    - https://gitlab.com/gitlab-org/gitlab/-/issues/335214
    - https://gitlab.com/gitlab-org/gitlab/-/issues/335211
    
    Related discussion in :
    
    -
    https://gitlab.com/gitlab-com/gl-infra/production/-/issues/5069#note_618889225
    2d15b97d
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7