[#QB-3216] Maintenance oF QuickBuild database

QuickBuild

Maintenance oF QuickBuild database

Created: 09/Jul/18 02:38 PM Updated: 14/Jul/18 12:51 AM

Component/s:

None

Affects Version/s:

8.0.5

Fix Version/s:

None

Original Estimate:	Unknown	Remaining Estimate:	Unknown	Time Spent:	Unknown
Environment:	Linux

Description

« Hide

We are using PostgreSql for our QuickBuild database, and the database is running out of disk spaces sometimes. We have a maintenance job which checks several QuickBuild configurations every 30 minutes to see whether they are as desired. If not, it modifies them. Recently there were some reasons, these configurations were modified every 30 minutes, and this took a lot of disk spaces of the database. Could you please give me recommendations on maintenance of the QuickBuild database?

Thank you in advance,
ptrinh

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Robin Shen [09/Jul/18 11:38 PM]

This is due to the fact that PostgreSQL does not purge LOBs automatically even if they are no longer being used. I'd suggest to write some form of stored procedure at PostgreSQL side to purge unused LOBs periodically as suggested here:
https://www.postgresql.org/docs/9.1/static/vacuumlo.html

[ Permlink | « Hide ]

Phong Trinh [13/Jul/18 03:04 PM]

Thank you for the suggestion, Robin.