RDS production Instance downsize

Question

I have a RDS DB PostgreSQL Machine with 2 VCPU and 8 GB RAM , from all the metrics I am seeing I can reduce this instance ( I have 5 GB Free memory and the other metrics are all very low ), I am thinking of downsizinh to a 4GB RAM machine , but this is my most important production database machine and I just wanted to know if it is okay to have 1/2 GB free memory on a production machine or not ? Thank you

Accepted Answer

Hello.

If you do not expect high loads to occur on RDS in the future, you may want to change to the next lower instance type.  
However, if you cannot predict the future load situation, I think it would be safer to leave some leeway in the specs, so I think you can leave the instance type as is.  
If you enable Multi-AZ configuration, you can reduce downtime when changing instance types, so even if you want to return to the original instance type after downsizing, you can quickly change it.  
https://repost.aws/knowledge-center/rds-mysql-downtime-impact

If you can afford to migrate RDS PostgreSQL to Aurora PostgreSQL, you may want to consider using Aurora Serverless.  
Aurora Serverless automatically changes specifications within the specified ACU (spec) depending on the load situation, which may lead to cost reductions.  
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.html

RDS production Instance downsize

Contenuto pertinente