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!

  • OdiousStoogeOP
    link
    fedilink
    arrow-up
    1
    ·
    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?

    • OdiousStoogeOP
      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