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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠