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!

    • OdiousStooge@lemmy.mlOP
      link
      fedilink
      arrow-up
      0
      ·
      1 year ago

      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?

      • OdiousStooge@lemmy.mlOP
        link
        fedilink
        arrow-up
        1
        ·
        1 year ago

        If anyone stumbles across this, the command to connect to the DB is (run from the root of your lemmy install - assuming a docker install):

        docker-compose exec postgres psql -U lemmy