Summary
Error
RTSM database which is one of the schema of the OBM, size was growing.
The most of the schema size was occupied by the content_packs table.
Cause
The cause for the database size increase is content_packs table. The content_packs table contains the content_pack .
The content pack was not able to insert into this table and it was timing out. Because of this every time it starts to insert into this table and used to fail.
This was causing the content_packs table to increase as every failure used to insert some data.
Fix
We increased the timeout value for statement in the postgress database.
Login to RTSM database instance
psql -u <RTSM instance>
set statement_timeout to 60000;
commit;