Aurora PostgreSQL: Repeated periodic write IOPS spikes after upgrade to 13.6

1

We recently upgraded from PostgreSQL13.5 to 13.6 and since then have seen a pattern of spiky write IOPS activity. The database receives batch updates once daily and has very little query traffic. We are experiencing these spikes even when there is no user activity on the database. The data updates that occur are almost entirely additive -- that is, there are little to no updates or deletions. The cluster has a single instance with no replicas.

Given the timing of this behavior, it seems likely it is connected to the upgrade as nothing else has changed. An image of the CloudWatch Write IOPS stats can be found here: https://postimg.cc/fVWjbTdn

  • I'm seeing the same behavior on a freshly created aurora postgres 10.20 instance. Were you able to find anything else out about what is going on?

已提問 2 年前檢視次數 438 次
1 個回答
0

Performance Insights will be helpful to identify the issue.

AWS
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南