Why changing RDS aurora postgres from a db.t4g.medium (2vcpu) to a db.r6g.xlarge (4vcpu) descrease the number of commited transactions?
Hello.
I was having CPU usage issues where the CPU would reach over 50%. So I upgraded from a db.t4g.medium to a db.r6g.xlarge. Now, all is good and running smooth.
But one thing intrigues me: Why after the upgrade, represented in the image by the red line, did the number of committed transactions decrease?
https://i.ibb.co/jJBwWZg/Captura-de-Tela-2022-04-12-a-s-17-28-32.png
- 최신
- 최다 투표
- 가장 많은 댓글
hello,
I understand that you changed number of vcpu , from 2vcpu to 4vcpu, but you see a decrease on number of commits. please correct me if i misunderstood you.
I can see from the screenshot, you are using too much cpu which is good. but the number of commits is purely your workload. so meaning that's the amount of workload you pushed to your database, you control that, remember that is just a counter like calls that are been made to desk
Note that you are the only one who can decrease the number of commit transaction. For more information about db.Transactions.xact_commit.avg please refer to this link[1]
I hope i was able to help you.
Reference link
