Some Postgres extensions need to be updated
Many extensions have outdated versions in gitlabhq_production, worth upgrading (after thorough testing):
| ▼ Database | Extension name | Installed version | Default version | Is old |
|---|---|---|---|---|
| gitlabhq_production | btree_gin | 1.0 | 1.3 | OLD |
| gitlabhq_production | btree_gist | 1.5 | 1.5 | |
| gitlabhq_production | dblink | 1.2 | 1.2 | |
| gitlabhq_production | pageinspect | 1.5 | 1.7 | OLD |
| gitlabhq_production | pg_buffercache | 1.2 | 1.3 | OLD |
| gitlabhq_production | pg_repack | 1.4.5 | 1.4.5 | |
| gitlabhq_production | pg_stat_statements | 1.4 | 1.6 | OLD |
| gitlabhq_production | pg_trgm | 1.3 | 1.4 | OLD |
| gitlabhq_production | pgstattuple | 1.4 | 1.5 | OLD |
| gitlabhq_production | plpgsql | 1.0 | 1.0 |
The most important here is, of course, pg_stat_statements and, I suppose, btree_gin and pg_trgm.
The others (pageinspect, pg_buffercache, pgstattuple) are tools for DBA tasks (ad hoc analysis of the state of the database).
cc @Finotto
Edited by Nikolay Samokhvalov