[GENERAL] Two-phase commit case studies - Mailing list pgsql-general

From Gavin Wahl
Subject [GENERAL] Two-phase commit case studies
Date
Msg-id CAAAf5g_a7whFpVWd0cPV_XPs7tbLhLn5PL=zvDu1qddSEEev2A@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Two-phase commit case studies  (Michael Paquier <michael.paquier@gmail.com>)
Re: [GENERAL] Two-phase commit case studies  (Jerry Sievers <gsievers19@comcast.net>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Planner statistics usage for composite type
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Two-phase commit case studies