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
Description
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
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
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
https://www.postgresql.org/docs/9.1/static/vacuumlo.html