the result is 190 Gb and if we look into the tables size, the table “file_sources” has a size of 52 Gb.
As a workaround, we have deleted manually all the PRs and branches analysis previous to a certain date, and we have manually deleted all the “file_sources” table rows previous to a certain date regarding to the condition above.
After that, we have looked that the size of the database and the “file_sources” table remains the same.
The DBCleaner parameters in our Sonarqube instance are set by default and works well.
Hi Colin and thanks in advance for your quick answer,
Theorically, in the pgAdmin database properties the AUTOVACUUM property is set to 1, so theorically the AUTOVACUUM operations must be done automatically.
Here are the autovacuum properties of our Sonarqube Postgre database:
We don’t know if this properties are OK or not, but are the default properties I think.
Regarding to VACUUM operations, we don’t know exactly if it should be done a VACUUM FULL for all the database or only a VACUUM and what kind of result must throw this command.
Finally, our database is not corrupted at all, so we are sure of this. Neverthless, we’ll be more careful to not update or delete anything in the database directly.