Must-share information (formatted with Markdown):
-
which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension) 7.9.3
-
what are you trying to achieve. Our POSTGRES DB is growing and we identified below tables are growing
public.project_measures | 72 GB
public.ce_task_input | 25 GB
public.file_sources | 6908 MB
public.issues | 3576 MB
public.projects | 1270 MB
public.ce_scanner_context | 560 MB
public.issue_changes | 545 MB
public.webhook_deliveries | 90 MB -
what have you tried so far to achieve this – Vacuum DB but still the same result DB is not shrinking or size is reducing…
We need steps to reduce the DB size in a healthy way, we have also deleted some unused projects say around 100 projects but still the space is same.
How to reduce the tables project_measures and ce_task_input ?