Sonarqube db migration 6.7 -> 7.6

[ganncamp (G Ann Campbell)]

Hi,

There was recent discussion about drive type affecting upgrade performance:

Upgrade process extremely slow because of very big PROJECT_MEASURES table (85 million rows)

Hello, just for the record: Today I migrated SQ 5.6.6 to SQ 6.7.6 (PostgresSQL 10) Sizes after migration: relation | total_size --------------------+------------ project_measures | 19 GB projects | 834 MB duplications_index | 782 MB file_sources | 640 MB snapshots | 253 MB issues | 99 MB ce_activity | 69 MB issue_changes | 62 MB events | 45 MB rules | 12 MB project_measures contains ~ 32M rows …

Beyond that, there’s a note about Oracle cleanup in the docs starting with 6.6 that might be relevant:

Upgrade guide

 
HTH,
Ann