3 ms·
Still hoping for a transaction manager so I can implement 2PC using postgres_fdw.
by arusahni 6y ago
Still hoping for a transaction manager so I can implement 2PC using postgres_fdw.
- skyde 6y agoI don't know your use-case exactly but every distributed system engineer should know that 2PC is extremely dangerous. It is a blocking protocol, This mean if the coordinator crash , some participants will never resolve their transactions. After a participant has sent an agreement message to the coordinator, it will completely block until a commit or rollback is received from the coordinator but this will never happen.
- arusahni 6y agoThanks for the warning - I agree that there are dragons. I have some well-constrained use-cases, and would love to obviate the need for "yet another microservice."