Issue with Postgre RDS

0

I have a Postgre RDS instance running in a t3.medium. I am running a code that reads a csv in 250k chunks abd my issue is that after I bulk insert this 250k rows in a table, the database seems to get stuck for many hours till the next bulk insert occurs.

Augusto
已提问 6 个月前246 查看次数
1 回答
0

Hi Augusto!

Can you provide more details on your issue to help you? Also, can you look at your RDS metrics while the process runs? https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Monitoring.html

Sometimes may happen that the RDS reaches the max CPU or the script that is inserting the data reaches a bottleneck neck so more details will be crucial to support you.

Is the script optimized to insert data? Are the indexes on the database causing any issues? What type of data are you inserting?

Hoping to get some feedback from you!

已回答 6 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容