RDS daily cost increased 3x after upgrading aurora postgresql from 10.13 to 13.4
0
The cost increased 3x since the day aurora postgresql was upgraded from 10.13 to 13.4 with code and instance type remaining the same.
Buffer Cache hit ratio fluctuates between 85 to 100 over a 1 minute interval.
Read IOPS is between 0 to 8000
Write IOS is between 0 to 1000
CPU usage is under 30%
Freeable memory is around 14000 MB
This is in our dev database. Simulating a load test against the test db didn't make any difference in the above numbers.
Other than the cost increase, performance is acceptable and all works well.
After a few days of cost increase, ran ANALYZE command the 2nd time. Improved buffer cache hit ratio that fluctuates from 85 to 100 (previously it was from 62 to 100 over a 1 minute interval). Still it does not stay close to 100.
shared_buffer_size is about 75% instance size which is the default.
Enabled Performance Insights on this RDS database. Shows some SQL commands like autovacuum: ANALYZE tablename requiring I/O access.
AWS 공식업데이트됨 일 년 전
