@alienghic I moved from octodon.social to a self-hosted single-user GoToSocial instance that I installed on the server I already had for all my other stuff (costing me €15/mo for 75GiB of disk, a few GiB of RAM); I started with all the accounts I knew from my old account so getting connected was easy; there is no moderation since it's just me I guess.

# du -sh /home/gotosocial
17G	/home/gotosocial

Monit claims that gotosocial uses 182.5 MB of RAM.

I'm not quite sure this answered your question?

Since I have a lot of weird web server settings, getting it all to work with GoToSocial was a bit tricky. If you have a default install, it should be easier. This was the last blog post on the topic, I think: https://alexschroeder.ch/view/2022-12-22_GoToSocial_instead_of_snac

I've never had any problems upgrading GoToSocial since then. Using a single SQLite file is great, no extra database required.