One of the most important things I’ve heard in the last few years was Michael Dexter’s comment about OpenZFS at AsiaBSDCon 2019. I’ve paraphrased it here a few times:
Once we lose data once, on any platform, people won’t trust us again.
Bruce Momjian also wrote about this in the context of databases last week, emphasis added:
Having worked with databases for over three decades, I have found there are three aspects of database software that make it unique: Variable workloads, performance requirements, and durability.
Most other software do not have these requirements. Because of them, databases typically need more tuning, monitoring, and maintenance than other software, like Java applications or even operating systems.
He linked to an article he wrote in 2012: You Lock Your Data in Postgres — We Cannot Fail. It’s a good read, and also introduces the responsibility of supplying reliable hardware. But the stakes are still fantastically high to get this right on the software side, and to tolerate the real world conditions in which it’s expected to work.
I’d trust Postgres over other DBs for mission critical work in a similar vein to what Michael and Bruce raise above: it’s proven itself durable and trustworthy. Trust is hard to earn, and easy to lose.