Postgres is more than good enough for almost every imaginable use case. Administration can be a bit of a problem if you're not familiar with it but AWS and most

Postgres is more than good enough for almost every imaginable use case. Administration can be a bit of a problem if you're not familiar with it but AWS and most other clouds have managed options if you choose to move to the cloud. I did use RethinkDB way back when there was a commercial company behind it but it was not stable enough under high load. It would occasionally crash with segfaults. Maybe those issues are now fixed but if you need reliability then Postgres is the way to go.