147
Where does Lemmy store upvotes, downvotes, and replies?
(lemmy.world)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 15 Oct 2023
147 points (100.0% liked)
Asklemmy
43866 readers
1755 users here now
A loosely moderated place to ask open-ended questions
Search asklemmy ๐
If your post meets the following criteria, it's welcome here!
- Open-ended question
- Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
- Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
- Not ad nauseam inducing: please make sure it is a question that would be new to most members
- An actual topic of discussion
Looking for support?
Looking for a community?
- Lemmyverse: community search
- sub.rehab: maps old subreddits to fediverse options, marks official as such
- !lemmy411@lemmy.ca: a community for finding communities
~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~
founded 5 years ago
MODERATORS
How much RAM does your server have to handle a 30 GB database?
I'm a bad example. I haven't properly tuned the settings, currently RAM will grow to whatever is available.
I'm very lucky, the instance is running in a proxmox container alongside some other fediverse servers (run by others), on dedicated hardware in a datacentre. The sysadmin has basically thrown me plenty of spare resources since the other containers aren't using them and RAM not used is wasted, so I've got 32GB allocated currently. I still need to restart once a week or that RAM gets used up and the database container crashes.
It's been on my list of things to do for a while, try some different postgres configs, but I just haven't got around to it.
I know a couple of months back lemmy.world were restarting every 30 mins so they didn't use up all the RAM and crash. I presume some time and some lemmy updates later that's no longer the case.
I know some smaller servers get away with 2gb of RAM, and we should be able to use a lot less than 32GB if I actually try to tune the postgres config.