Any helpful tips for general care and feeding I should be doing on a regular basis?
I know I need to keep an eye on updates and re-run my ansible setup form time to time to stay up to date.
But I have also been keeping an eye on my VPS metrics to see when/if I need to beef up the server.
One thing I am noticing is a steadily increasing disk utilization (which mostly makes sense except its seeming a bit faster than I expected as most all media is links to external sites rather than uploading media directly to my instance).
Anything I can do to manage that short of just adding more space? Like are there logs/cached content that need to be purged from time to time?
Thank you!
Gotcha thanks! Thats good to know. Based on the originating ticket: https://github.com/LemmyNet/lemmy/issues/1133
Sounds like it might be safe for me to purge that table a bit more often as well.
Dumb question, how are you profiling (RE your mention of getting a better idea of which tables might be bloated) your DB? Just SSHing into your box and direct connecting to DB? Or are there other recommended workflows?