Vouching parent comment. The last time I looked at Postgres, I was really happy to see that BDR was now doable without a patched Postgres. But, I believe transactions affecting multiple tables didn't fully work yet.

Postgres is my preference over MySQL/MariaDB, but I wouldn't have pushed for it back when I worked in traditional corporate IT: Stability, and having a third-party to blame, really wins there!