Was it unusable because cpu/io was maxed out during ANALYZE?

Analyze itself isn’t the problem.

After pg_upgrade, no stats will be available for the optimizer which means that any query will more or less sequence-scan all affected tables.

No, its the lack of stats on the tables, any query hitting a medium to large table would be extremely slow.

Lambda is returning 502 errors in US-West for me as well.

yes. Having issues as of few mins ago reaching us-west-2 ec2.

us-west-2 EC2 looks like just came back online.

wohoo! ssh'd back in. ty

I agree. This is likely a result of central bank policies pushing rates down for so long. I bought recently because rates are so extremely low and the govt has committed to keeping them low for a long time. Rates went up very slowly after the Great Recession and this time will probably be the same. Add to that a growing population (here in Canada) and housing prices will probably keep going up a lot.

I agree with what you are saying but you can't compare jQuery and React - they are very different tools.

If something works for you and makes life easier then you should use it. There is no right answer. You just need to be honest with yourself when planning things out - am I using this technology because it's new and shiny or because it is the right tool for the job right now.

> I agree with what you are saying but you can't compare jQuery and React - they are very different tools.

I am well aware. It was mostly a joke :]