Databases - Maintenance tasks

[kostasgrevenitis]

The DevOps team should run critical maintenance tasks. This includes making sure the three main DBs we have (CrateDB, MongoDB, Timescale) perform well---e.g. run Postgres vacuums, review resource allocation, make sure we have enough storage capacity, etc.

• Postgres Vacuum: https://www.postgresql.org/docs/current/sql-vacuum.html
• MongoDB compact: compact — MongoDB Manual
• Timescale vacuum: https://www.timescale.com/forum/t/what-is-the-right-way-to-vacuum-chunks-after-data-is-deleted/704

Of course, the databases must be backed up first.