action #100859
Updated by okurz over 2 years ago
## Motivation Over 80% space of /srv on OSD are used up. Most of this data is used by our postgresql database. I raised this concern in [slack](https://suse.slack.com/archives/C02AJ1E568M/p1634030652186600) where some possible reasons where discussed. One of them is to figure out why postgresql uses so much data. @mkittler mentioned that a fresh database import lowers disk space consumption drastically. Also see [poo#89821](https://progress.opensuse.org/issues/89821) for some history about the alert itself. ## # Acceptance Criteria **AC1**: Alert does not trigger any longer **AC2**: Understand why our production database uses the space it uses ## # Suggestions * Enlarge partition by opening an eng-infra ticket and ask for some more space for /dev/vdb * Figure out if the disk utilization of our database can be optimized * Try if the disk utilization can be reduced. E.g. by running the postgresql vaccum * See if an auto vaccum can be configured or if thresholds can be lowered (https://suse.slack.com/archives/C02AJ1E568M/p1634033225193500?thread_ts=1634030652.186600&cid=C02AJ1E568M)