Re:Postgres transactions are a distributed systems superpower
by dcminter on Friday July 03, 2026 @09:11AM
(#48774607)
Ah, you're assuming distributed, which I wasn't. We are not at home to partition tolerance :)
Makes sense in the context of the original post though.
Re:Postgres transactions are a distributed systems superpower
by pragmatic on Friday July 03, 2026 @10:08AM
(#48775277)
But you are assuming distributed transactions as soon as you have two systems participating in the transaction.
It's a recipe for deadlocks and even live locks.
That's a reason industry moved away from this. Bc when it works it's magic. But when the problems start it's pure hell.
If you invoke 2PC, you want the states to progress thus:
A strictly harder problem, right?