Since I currently use Hetzner the only way to get more space is to upgrade the server (at a not inconsiderable cost).
The alternative might be to purchase SSD block storage volumes which are definitely lower priced (5€ per month for 100GB) however it would be interesting to know if there is a guide for Lemmy for this or if others have had positive experience doing this.
Since this problem I think is quite common (at least from reading a few threads and comments around) it might be interesting to create a guide especially regarding the part of having lemmy use this/mounted volume instead of the default one.
I in the meantime will try to look around for some information on how this can be done, any advice is definitely welcome.
How to free up space pictrs or postgres (feddit.it)
Hello, I have 160GB to run Lemmy but I saw that as much as 77GB is used by pictrs....