# Live\_measures table keeps growing despite of project deletions

**URL:** <https://community.sonarsource.com/t/live-measures-table-keeps-growing-despite-of-project-deletions/13325>\
**Category:** SonarQube Server / Community Build\
**Created:** [August 20, 2019, 1:38pm UTC](https://community.sonarsource.com/t/live-measures-table-keeps-growing-despite-of-project-deletions/13325 "2019-08-20T13:38:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![andresmiguel](https://avatars.discourse-cdn.com/v4/letter/a/b19c9b/32.png) [@andresmiguel](https://community.sonarsource.com/u/andresmiguel)\
**Post date:** [August 20, 2019, 1:38pm UTC](https://community.sonarsource.com/t/live-measures-table-keeps-growing-despite-of-project-deletions/13325/1 "2019-08-20T13:38:37Z")

</div>

Must-share information (formatted with [Markdown](https://commonmark.org/help/)):

- which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)  
Sonarqube Community Edition 7.7 (build 23042), sonar-maven-plugin:3.6.0.1398, external RDS DB PostgreSQL 9.6.11
- what are you trying to achieve  
Reduce DB size.
- what have you tried so far to achieve this  
Delete a bunch of projects.

---

<div class="post-metadata">

**Author:** ![ganncamp](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/ganncamp/32/1261_2.png) [@ganncamp](https://community.sonarsource.com/u/ganncamp)\
**Post date:** [August 21, 2019, 1:58pm UTC](https://community.sonarsource.com/t/live-measures-table-keeps-growing-despite-of-project-deletions/13325/2 "2019-08-21T13:58:26Z")

</div>

Hi,

This is strikingly similar to this thread:

> [@Sonarque DB cleaner Issue](https://community.sonarsource.com/t/sonarque-db-cleaner-issue/13229/2):
>
> Srikanth, SonarQube will mark data as deleted, but it is up to the database engine to reclaim free space (like a postgres [vaccum](https://www.postgresql.org/docs/9.1/sql-vacuum.html)). Colin

&nbsp;  
Ann

---

<div class="post-metadata">

**Author:** ![andresmiguel](https://avatars.discourse-cdn.com/v4/letter/a/b19c9b/32.png) [@andresmiguel](https://community.sonarsource.com/u/andresmiguel)\
**Post date:** [August 21, 2019, 2:02pm UTC](https://community.sonarsource.com/t/live-measures-table-keeps-growing-despite-of-project-deletions/13325/3 "2019-08-21T14:02:16Z")

</div>

Hi Ann  
I will take a look at that and I’ll let you know.

Thank you.