Latency increases as I add more and more data into AWS RDS postgres table.

Question

we have our data in AWS RDS postgres db. We have a table with around 100-200 rows and we loaded up 200M rows in 3 hours timeframe. That table is indexed as well. And now we want to insert more data into the table and we see that adding 20M rows is taking 5 hours.
Our instance size is db.r6g.xlarge. And we have two AZ. I want to know the reason for slower performance in query operation and what is the best way to import that huge data into postgres table.

Answer

To answer your question, we require details that are non-public information. Please open a support case with AWS using the following link:

[+] https://support.console.aws.amazon.com/support/home?#/case/create

Further, you can go through following AWS blogs and knowledge-articles to troubleshoot performance issues :

[+] https://aws.amazon.com/premiumsupport/knowledge-center/rds-aurora-postgresql-performance-issues/

[+] https://aws.amazon.com/blogs/database/optimizing-and-tuning-queries-in-amazon-rds-postgresql-based-on-native-and-external-tools/

[+] https://aws.amazon.com/premiumsupport/knowledge-center/rds-aurora-postgresql-query-blocked/

[+] https://aws.amazon.com/premiumsupport/knowledge-center/rds-write-latency-spikes/

Latency increases as I add more and more data into AWS RDS postgres table.

Relevant content