Massive Disk Space Reduction After SonarQube Upgrade (9.9 → 24.12) with PostgreSQL Upgrade

I’m observing a very large disk space reduction after upgrading SonarQube and would like to confirm whether this behavior is expected.

Previous Setup

  • SonarQube Version: 9.9 LTS

  • Database: PostgreSQL 12 (AWS RDS)

  • Running on EC2 (Docker container)

  • Total EBS Volume: 1000 GB

  • Used Space Before Upgrade: ~682 GB

  • Available Space Before Upgrade: ~318 GB

Upgrade Performed

We upgraded SonarQube following the supported path to 24.12 and also upgraded PostgreSQL from 12 → 15 during the process.

After the upgrade:

  • Available disk space increased from 318 GB → 872 GB

  • So nearly ~550 GB disk space got freed

  • All projects, history, and dashboards are visible and working correctly

Observation

No data seems missing:

  • All projects exist

  • Measures & issues visible

  • Background tasks completed successfully

  • No migration errors in logs

Question

Is such a massive storage reduction expected during SonarQube upgrade + DB upgrade?

Could this be due to:

  • Cleanup of old analysis snapshots / orphan data

  • ES index restructuring

  • DB schema optimizations / table compaction

  • Removal of deprecated tables from older versions

Has anyone else experienced similar large size reductions after upgrading from 9.9 → 24.12?

Thanks!

Hi,

I think this is what you’re looking for:

SONAR-22870 [10.8] Compress live_measures table

 
HTH,
Ann

2 Likes