By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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.

Topics
Database
Tags
PostgreSQLDatabase
Language
English
Augusto
asked 5 months ago239 views
1 Answer
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!

Jesus Castellanos
answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content