Story about a problem we had with the cyberia.club matrix server and how I went.... just a *little* bit overboard on solving it :

https://sequentialread.com/matrix-synapse-out-of-disk-space-state_groups_state/