c0c0n3 / kitt4sme.live

On a mission to bring AI to the shop floor: https://kitt4sme.eu/
MIT License
1 stars 27 forks source link

Databases - Maintenance tasks #445

Open kostasgrevenitis opened 3 months ago

kostasgrevenitis commented 3 months ago

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.