Tenant manager DB size grew more than 200 GB

Products

• VCF Automation

Issue/Introduction

Tenant Manager database size increases significantly, in some cases exceeding 200 GB. This growth is primarily driven by the activity table, which continues to consume disk space even after data deletion.

Environment

VCF Automation 9.x 

Resolution

Engineering is actively working on a permanent fix, which will be included in a future release.

As a workaround, execute the following query to generate VACUUM FULL commands for the activity tables:

SELECT 'VACUUM FULL VERBOSE ' || tablename || ';'
FROM pg_tables
WHERE tablename LIKE 'activity%' 
ORDER BY tablename;

Additional Information

The VACUUM FULL operation requires sufficient disk space and may lock the tables during execution. It is recommended to perform this operation during a maintenance window to avoid impact on running services.