Two-phase commit case studies

From: Gavin Wahl <gwahl(at)fusionbox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Two-phase commit case studies
Date: 2017-07-19 17:10:52
Message-ID: CAAAf5g_a7whFpVWd0cPV_XPs7tbLhLn5PL=zvDu1qddSEEev2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I've read the documentation for two-phase commit and it sounds interesting, but
I'm having trouble thinking of how to actually put it into production. How are
people using it? Do you use a XA transaction manager or something custom built?
How dos the reconciliation work when a component crashes between PREPARE and
COMMIT? Is anyone using it in the open-source world where transaction managers
are unheard of?

Looking forward to hearing about how two-phase commit has helped you.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-07-19 17:23:57 Re: Two-phase commit case studies
Previous Message Tom Lane 2017-07-19 16:18:07 Re: Planner statistics usage for composite type