What is the damage to the database if it uses high memory storage? Are there consequences for this use? Does it affect performance?

Question

What is the damage to the database if it uses high memory storage? Are there consequences for this use? Does it affect performance? I need to understand a lot about this problem to be able to create solutions to it

Answer 1

To add on to danblack's point, it's generally good for your server's memory to be mostly consumed by the database system because accessing data from memory is faster than disk, but if you don't have enough memory to support your database system's workload then you can run into performance issues when it needs to pull from disk or compensate in other ways.

If you updated your question with the specific issue you're trying to solve then we can provide more specific information, but if you're just generally asking then you don't have to worry too much about this until you run into performance issues. There's a lot of other things that can equally or more likely affect performance before memory provision does.