Execute maintenance on GitLab.com
Execute repacking maintenance on GitLab.com for indexes and selected tables (see below).
For selected tables, we also want to execute table maintenance. Those tables are the outliers based on the analysis in gitlab-com/www-gitlab-com!18277 (merged).
Those tables are:
services
snippets
The maintenance should be rolled out iteratively (with increased risk/impact):
- Repack normal index
- Repack primary key
- Repack full table
User creation
- Create specific user for repacking
- Set
idle_in_transaction_timeout
Edited by Andreas Brandl