4gb is not a lot for a db. And it has to share it with lemmy and pictrs. It might not be enough with the standard config. Even then it might struggle if you subscribe to a lot of communities. You have to remember that every instance replicates everything the users are subscribed to. I am not sure though because my server hosts several applications and I have enough RAM.