Slow queries for results.openaddresses.io about machine HOT 2 CLOSED

I ran the following SQL the other night:

machine=> create table runs_archive as select * from runs;
SELECT 991904

But then this delete was taking 18+ hours:

machine=> delete from runs where id <= 564648;

So I canceled it and moved the RDS instance over to a larger instance type. Queries are much faster now, but the instance is more expensive, so I'm going to try making it smaller again and see if creating a new instance helps.

from machine.

I moved the instance type back to the original and it seems to be happier now. I think the previous instance, having sat around running for multiple years without stopping, was just broken.

from machine.