En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
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.

Sujets
Base de données
Balises
PostgreSQLBase de données
Langue
English
Augusto
demandé il y a 6 mois246 vues
1 réponse
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
répondu il y a 6 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents