QA (public) » openQA Project (public) » openQA Infrastructure (public)

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 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 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
• DONE by coolo: 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) -> #100979
• better alerts -> #100976