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 ?