The thing is, if your database goes down, it likely needs to stay down until you understand why it went down and whether it's business-safe to turn it back. PostgreSQL almost does not crash. And when it does, you should care about your system's stability, and a crash is a giant message about stability.

Plan for uptime and you'll be more likely to get it, than planning around a buggy server process.

(Also, in this case, it would have violated SOX and PCI rules, as well as general sanity, to host a 512GB 64-core server in the cloud)