Hi Ann,
As mentioned in my post (see quote). We have deleted aprox. 1000 projects with only about 600 remaining. We went from 32M LoC to aprox. 8M LoC and the database size after a VACUUM FULL was not changed by the same ratio. At the moment we’re at a database size of 430GB (almost double after the big cleanup) while the projects (+66) and LoC (+3M) have grown slightly since.
Deleting 2/3 of the projects that were stale through the SonarQube WebUI
Same as the OP in the linked post I’m not a DBA. I will try the suggested fix (link) to see if this will solve anything. We have been performing the DB maintenance tasks like VACUUM regularly.
I will report back after trying the check.
Kind regards,