>150Million records insert select query canceled after 12 hours AWS RDS

I have a AWS RDS t2.micro storing over 150 million records in a table from which i need to make a select insert query to another table, the purpose of this select query is to make a percentage calculation into second table.

I tested this query in a testing db with less than 100 rows(same t2.micro) and it ran correctly. I think the query is being canceled because of the t2.micro capabilities.

I'm considering upgrading the RDS from t2.micro to r6g.large, but im not sure if this will solve my problem, any suggestions?

Why don’t you try it? M6g.large costs $3.60/day - you’ll hardly get broke on that. Also you can use a bigger instance for inserting the records and downsize when done.

Beside that check out the Monitoring tab in the RDS console and see if anything happened at around the time your query failed. You may want to enable ‘T2 Unlimited’ to prevent running out of CPU credits.

Hope that helps :)