Actions
action #100988
closedask for OSD /srv to be enlarged (was: investigate how to optimize /srv data utilization on OSD) size:S
Start date:
2021-10-12
Due date:
% Done:
0%
Estimated time:
Tags:
Description
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)-> #100979better alerts-> #100976
Actions