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ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ