Can PostgreSQL table partitions reduce Aurora DBLoadNonCPU and IO:XactSync wait events?

0

My system has a write intensive workload largely consisting of deletes and inserts. The work is applied by drawing from queues such that I can control the concurrency. The transactions touch about 100 tables with a handful being much larger than the rest by row count (several hundred million rows) . There are foreign keys and indexes present.

I'm finding that my transaction throughput is at best the same as I could do with a RDS multi-AZ cluster that was half the size (4xlarge vs 8xlarge). The bottleneck I identified with Cloudwatch and Performance Insights are from DBLoadNonCPU / io:xactsync wait events. If helpful, it is possible to drop the foreign keys, but we are not able to change the composition of our transactions. Would PostgreSQL table partitions help with this?

沒有答案

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

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

回答問題指南